If you want to compare the 2 tables you have to join them:
select * from listings, fake where listings.id=fake.id;
If you do your query SELECT * from listings where listings.id = fake.id; it
simply doesn't know where to get fake.id
>From: Ed Curtis <ed@stripped>
>Subject: SELECT ERROR
>Date: Wed, 23 Feb 2005 08:02:21 -0500 (EST)
>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.
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
Want to block unwanted pop-ups? Download the free MSN Toolbar now!