At 07:23 PM 9/19/01 -0500, "DanielW" <[EMAIL PROTECTED]> wrote: >I have 2 tables, clients and orders. I'm trying to generate a >sales report for our rep. I need to display several generic >columns from customers along with the date of the customer's >last order. If there are no orders for the customer in the >system, then I still want the customer record to appear. Dan, A typical scenario to use the SELECT command with OUTER JOIN! For complete details and syntax: http://www.RSyntax.com Under Syntax Reference, check out OUTER JOIN. Have Fun! Very Best Regards, Razzak. ===================================-============================ Official R:BASE List Server: mailto:[EMAIL PROTECTED] RBTI Events/Training: http://www.rbase2000.com/events R:DCC Members: http://www.rbase2000.com/rdcc ================================================================ R:BASE, Oterro & R:Tango are registered trademarks of RBTI. ==================================-=============================
