Querie problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi need help.
I'm trying to make a querie that returns values in two diferent tables.
Table 1 returns the name of the employee and the time he worked that month.
Table 2 returns the number of vacation days that the employee has used in
that month.
I'm quering using a date interval. But then if the employee had no vacations
this month the querie doesn't show is working hours, this month.
Could some one help me please.
Thanks in advanced.
 
Hi need help.
I'm trying to make a querie that returns values in two diferent tables.
Table 1 returns the name of the employee and the time he worked that month.
Table 2 returns the number of vacation days that the employee has used in
that month.
I'm quering using a date interval. But then if the employee had no vacations
this month the querie doesn't show is working hours, this month.
Could some one help me please.
Thanks in advanced.
Click to expand...

You probably need a Left Join instead of the default Inner Join. Could
you open the query in SQL view and post it here?


John W. Vinson[MVP]
 
Back
Top