select statement

From: Olaf.Lange@schering.de
Date: Fri Oct 01 1999 - 19:54:29 EST


Hi list,

please be patient with a newby in msql :-)
I have a problem with the select statement.
If I have two tables A and B where

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)
?

Thx a lot
Olaf

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