Re: How To Do 3-Way Join??

Try

SELECT a.rout_nbr


      ,a.rout_desc

      ,b.driver_nbr

      ,c.trailer_nbr

  FROM rout    a


      ,driver  b

      ,trailer c

 WHERE a.rout_nbr = b.rout_nbr
   AND a.rout_nbr = c.rout_nbr

or, if routes may have no driver and/or trailer use outer joins

SELECT a.rout_nbr


      ,a.rout_desc

      ,b.driver_nbr

      ,c.trailer_nbr

  FROM rout    a


      ,driver  b

      ,trailer c

 WHERE a.rout_nbr = b.rout_nbr (+)
   AND a.rout_nbr = c.rout_nbr (+) 

John Received on Thu Oct 23 1997 - 00:00:00 CDT