How To Do 3-Way Join??

From: Dianne Siebold <dsiebold_at_wrightstrat.com>
Date: 1997/10/23
Message-ID: <01bcdfde$d345c4f0$7593d4cc@patch>#1/1

I'm using Oracle 7.3.3 and need to join 3 tables and pull data out of each of them. The DRIVER and TRAILER tables could have multiple records for one route.

ROUT: ROUT_NBR, ROUT_DESC
DRIVER: ROUT_NBR, DRIVER_NBR
TRAILER: ROUT_NBR, TRAILER_NBR I'm looking for a result like this where a route could have two different drivers or two different trailers.

ROUT_NBR        ROUT_DESC         DRIVER_NBR                  TRAILER_NBR
1                        Route 1                        2                  
                    4
1                        Route 1                        2                  
                    5
2                        Route 2                        3                  
                    7
2                        Route 2                        4                  
                    7

Any assistance you can provide on SQL Syntax would be helpful. I have checked a number of manuals, but they have had little in the way of example code. Received on Thu Oct 23 1997 - 00:00:00 CDT