AnyOne help with this?? Join Query

[bsnapool]

Hi All,

Quick question...

If I were to do a right join on four different attributes E.g. a = a b = b etc etc and the criteria would be Attendance is null. I am getting the results back which I want but the columns which I have joins on are blank? Any ideas why?

Any help appreciated....

 

[David Eagar]

Is it a=a AND b=b or a=a OR b=b?

 

[bsnapool]

thanks for your reply...

It was my bad, had not changed the source data after copying the a previous query.

Thanks