I'm trying to compare 2 tables and keep getting an error. SELECT * from listings where listings.id = fake.id;
The error is "Error 1109: Unknown table 'fake' in where clause" or "Error 1109: Unknown table 'listings' in where clause" depending on the table order at the end of the query. Both tables do exist and I can select any or all contents from either of them seperately just not using the command above that practically comes straight from the documentation. Any ideas? Thanks, Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
