select * where a=1 if b=3
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)
?
Regards,
Talthen
Re: select * where a=1 if b=3
talthen.z-serwera.o2 [at] 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
Re: select * where a=1 if b=3
"J.O. Aho" <user [at] example.net>
> SELECT * FROM table WHERE (a=1 AND b=3) OR (a=b);
Heh, of course it's it. I just spent too many hours on programming today.
Thanks.
Regards,
Talthen
Re: select * where a=1 if b=3
Então vai dormir... simples...
--
Hélio,
Abraços
