Outer Join

[Guest_imported]

I have a sql statment that returns everything I want but if one cell in the DB for a row is null it will not return that whole row. I understand that I must accomplish this through an outer join statement but I am pulling data from a few diff tables. Attached is my SQL statement, I need to make sure that even if the Buddy field has nothing in it I want to pull that whole row back..... Thanks!

 

[rafe]

No SQL attached. O'well.

Actually you can do a lot with outer joins without actually coding in SQL directly. OR atleast in A2K.

The line that you see in the Query Builder that connects the tables/queries together is an object that has options. If you right click the line (kind of small & hard to hit) then choose "Join Properties".

At the bottom of the "Join Properties" Box will be three Option buttons. Options 2 & 3 are actually left & right outer joins. That is, selecting ALL records from one table & only matching records from the other (where there's a match on joining fields). An inner join selects only records where there’s a match in both tables/queries.

Left & right are from the order in which they'll appear in the SQL text. But I find point & grunt easier than trying to code SQL directly.

BTW: After you create outer joins via pointing & clicking you can examine the SQL code by going into SQL view for the query.