Hi Brian, Not answering your question, but are your table names really "table1", "table2" etc?
If so, you will be running into more problems :-) With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com > There has got to be a better way for me to query/subquery this data. > I have 4 tables. > > Table1 > ------------------------- > Company_Name | Company_ID > ------------------------- > Blue Shoe | 101 > Fast Cow | 102 > > Table2 > ------------------------------------------------------------------------ > --------- > Company_ID | Company_Location | Company_State | Company_area_code | > Company_Prefix -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]