This sounds like the same column name is in both tables and Witango is selecting the first instance. You change the table order or if you flip the join to flip the table/columns and use a right outer join instead of a left might do the trick.
Or you need to do DirectDBMS Ben Johansen -----Original Message----- From: John McGowan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 11:46 AM To: [email protected] Subject: Witango-Talk: Bad Table Name Replacing I have a query that joins the following tables. products as p1 cart_products as c2 however at one point in the query that is created by Witango, a reference to cart_products is showing up as "cart_p1" not "c2" Seems like witango is replacing products with p1 even if it is a partial table name match. Anybody else ever see anything like this? I'm forced to write this query as a DirectDBMS action.... ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
