Posted by J.O. Aho on 04/01/06 18:55

talthen.z-serwera.o2@nospam.pl wrote:
> Hello,
> How can I do a select like this:
> Select all records, where (record a=1 if record b=3) or (record a=record b)
> ?

SELECT * FROM table WHERE (a=1 AND b=3) OR (a=b);


//Aho

• Next in forum: Re: select * where a=1 if b=3
• Prev in forum: select * where a=1 if b=3
• Thread view: Re: select * where a=1 if b=3

[Reply to this message]