Hello Everyone, !!!!!!!!!Please help!!!!!!!!!!!!!!!!!!! I have a foxpro database on a solaris machine. I need to do a join between two tables. However, I can't use query1.abc and query2.xyz. It doesn't like anything with a dot in the middle for designation. Does anyone know what syntax works for SQL Query using CF 4.5.1 (Solaris) and Foxpro v3.0 ODBC connection for a statement like this: <cfquery name="q_sogrp" datasource="abc" dbtype="ODBC"> SELECT pohdr.po_number, pohdr.vend_name, pohdr.vendor_id, pohdr.po_amount, pohdr.org_po_dt, pohdr.pay_term, pohdr.ship_to_nm, pohdr.ord_status, podtl.itm_glmoco, podtl.ln_sta, podtl.ln_no, podtl.prom_dock FROM pohdr, podtl <!---FROM (pohdr INNERJOIN podtl ON (pohdr.po_number=podtl.po_number AND pohdr.vendor_id=podtl.vendor_id))---> #where# order by pohdr.po_number </cfquery> When I test on my server with NT installation of cf 4.5.1, it works fine but not on the client solaris server. Do I need to create index tables? Any suggestions are very much appreciated. Thanks, Nehal ---------------------------------------------------------------------------- -- Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
