Posted by jj on 10/13/25 11:28
thanks for the quick reply it works great, im trying to learn here, can you
explain why my statement wouldnt work? i have used such statements with the
AND operator with success before im just curious why the OR doesnt give the
right output.
"ZeldorBlat" <zeldorblat@gmail.com> wrote in message
news:1128438211.002350.119040@o13g2000cwo.googlegroups.com...
> select customers_email_address as email
> from newsletter
> where customers_email_address = 'test@test.com'
>
> union
>
> select email
> from customers
> where email = 'test@test.com'
>
Navigation:
[Reply to this message]
|