Outer Join 1

[SuperTime]

This is my report senario

Table A Table B
ID ------->ID
Date ------->Date
Time ------->Time
Pay

I want to join the above three fields of the two tables.

And want to display the Value of a feild named Pay from table B.

Now there are records in TABLE A that do not exist in TableB

for example:
ID 1111 is in table A but not in table B

I want to make an outer join so that It displays the ID feild of Table A on my report with the Pay value as null.

Please advice,

Thanks.

 

[kskid]

Go to Database->Visual Linking and simply change one of the links from an equal join to left outer join. Table A should be on the left. Once you change one of the links, then the other links will be changed automatically to a left outer join.

Cheers,

-LW

 

[SuperTime]

Thanks a lot. It worked.