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; it
> simply doesn't know where to get fake.id
>
>
> >From: Ed Curtis <[EMAIL PROTECTED]>
> >To: mysql@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,
> >
> >Ed
> >
> >
> >
> >--
> >MySQL General Mailing List
> >For list archives: http://lists.mysql.com/mysql
> >To unsubscribe:
> >http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
> _
> Want to block unwanted pop-ups? Download the free MSN Toolbar now!
> http://toolbar.msn.co.uk/
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



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
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,
Ed

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]

_
Want to block unwanted pop-ups? Download the free MSN Toolbar now!  
http://toolbar.msn.co.uk/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]