Querie problem

[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.

 

[John Vinson]

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.

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]