Left Outer Join
Posted on 2003-02-24
I have a primary table linked to a secondary table using a Left Outer Join.
In a report when I fetch records in the secondary table, I only fetch records matching the primary table and not those that are in the primary and not matched in the secondary.
I am using MS Access and Crystal Report 9 with latest patches.
I have read the knowledge base and understand that outer joins are non standard with regard to SQL however I would have thought MS Access would not be a problem.
Any clues. I do need an outer join since I will be using sub reports with side by side alignment of information.
Thanks in anticipation.