RE: SELECT ERROR - mel list_php - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlRE: SELECT ERROR

From	Sent On	Attachments
Ed Curtis	23 Feb 2005 05:01
Ed Curtis	23 Feb 2005 05:23
mel list_php	23 Feb 2005 05:35

Subject:	RE: SELECT ERROR
From:	mel list_php (list...@hotmail.co.uk)
Date:	02/23/2005 05:35:54 AM
List:	com.mysql.lists.mysql

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...@homes2see.com>

To: mys...@lists.mysql.com 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.

Any ideas?

Thanks,