Left outer join - Crystal 8.5 - Oracle

[Former Member]

Post Author: artztm

CA Forum: General

We have two tables. One has our 100 warehouse Door IDs. The second has Trailer IDs that are in any doors, and what door they are in. The join is on door field in each table. We want all doors to print whether there is something in the door or not. The only selection criteria I enter is against the Trailer table (I want all current trailers in a door). Seems like a simple Left Outer join example but I only get the doors to list where there is a trailer in the door. If I remove the current trailer criteria then I get every trailer that ever arrived in any door. Is what I am trying to do possible? My limiting select critieria is on the second table, but I want all data in table 1.

[Former Member]

Post Author: synapsevampire

CA Forum: General

That's how LO Join queries work.

Think about it, you state specifically only those with certain criteria on the right table, which is specifically stating do NOT show me those that do not have this criteria. If it did automatically show you those without that criteria, hwo could you ever code for those when you do NOT want the null ones???

Works the same way in almost every query language, this isn't a Crystal issue.

So you might try altering your Record Selection Formula to:

(isnull({table.field})or{table.field} = "blah")

-k