Posted by Geoff May on 05/23/05 18:43

Dave wrote:
> Hi,
>
> [snipped]
>
> if I try the following query, it returns incorrect cols for rows:
> SELECT table_1.ID, table_1.NAME if(table_1.ID = table_2.ID, table_2.FLAG, 0)
> AS MY_FLAG
> FROM table_1, table_2
> WHERE table_1.ID LIKE '1000%' ORDER BY table_1.ID;
>
> returns:
> ID NAME MY_FLAG
> 10001 10001 name 1
> 10001 10001 name 0
> 10002 10002 name 0
> 10003 10002 name 0

SELECT table_1.ID, table_1.NAME if(table_1.ID = table_2.ID, table_2.FLAG, 0)
AS MY_FLAG
FROM table_1, table_2
WHERE table_1.ID LIKE '1000%' ORDER BY table_1.ID
and table_1.ID = table_2.ID;

MfG

Geoff.

--
Unofficial F1 Database: http://glibs.ssmmdd.co.uk/
Update: 22nd May, 2005
USENET Email address is a spam trap, send Emails to address in the DB

• Next in forum: Re: MYSQL select question
• Prev in forum: right in script.
• Thread view: Re: MYSQL select question

[Reply to this message]