RE: SELECT ERROR

2005-02-23 Thread Ed Curtis
Thanks, as soon as I seen it I slapped myself really hard :) On Wed, 23 Feb 2005, mel list_php wrote: > 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;

RE: SELECT ERROR

2005-02-23 Thread mel list_php
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 <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Su