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@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"

> 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