Hi,
> Table A has two fields
> id int
> name char
>
> and
>
> Table B has two fields
> id int
> name char
>
> Is there a possiblity to do a select like the following:
>
> SELECT name.A AND name.B WHERE id.A=id.B AND (name.A = foo OR name.A=foo2)
Sure. You're nearly there...
Something like the following (not tested) should do it:
select a.name, a.id, b.name, b.id from a,b where a.id=b.id and (a.name = 'foo' ...)
Bye,
Georg
-------------------------------------------------------------------------
To unsubscribe, go to http://www.Hughes.com.au/extras/email/
This archive was generated by hypermail 2b30 : Mon Mar 04 2002 - 09:03:51 EST