Can you post the SQL? :) Did you use the Designer? If I recall correctly there was something it did with the order of the Join and ON clauses that caused problems - maybe that was the issue...
Lou -----Original Message----- From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On Behalf Of Jeff Johnson Sent: Thursday, November 10, 2011 7:29 AM To: profoxt...@leafe.com Subject: SQL Column not found I had this problem before and I couldn't find it in the archives. I am doing a select statement and I am getting an 1806 error "SQL: Column 'mycol' is not found. mycol is definitely in the table. You gave me an SQL clause that fixed this before but I can't find it. Something about using the drive instead of memory. Anyone remember that or have the solution? It is not in the VFP help file. -- Jeff --------------- Jeff Johnson j...@san-dc.com (623) 582-0323 www.san-dc.com [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/0bac2c1927422843b2c121c8b41684af0c82c...@dfw1mbx24.mex07a.mlsrvr.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.