Skip to Content
Former Member
Jul 03, 2007 at 10:39 PM

Left outer join - Crystal 8.5 - Oracle


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.