I tried your new query and got "Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Non unique column reference: date."
Mike -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Subject: RE: Having trouble getting variables from different tables to out put SELECT LI.OrderNum, LI.Status, LI.MainLine, LI.acct_id, LI.date, LI.po_num, H.reorder_num, H.control_num FROM QOrdLineItems LI INNER JOIN QHistRO H ON LI.OrderNum = H.reorder_num OR LI.OrderNum = H.control_num WHERE acct_id = <cfqueryparam cfsqltype="cf_sql_varchar" value="#COOKIE.id#"> ORDER BY date DESC ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272553 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
