Re: SQL Help
MATHER (MATHER@pop.erols.com) wrote:
: I have two tables, table a is a list of People, and table B is a
: descriptor field (i.e. Brown hair, Blue eyes, tall, skinny). Each
: description in Table B is a separate record. How can I get a report of
: all people who are not skinny.
: When I try
: select * from
: table A, Table B
: where tableb.desc <> "skinny"
: I still get guy1 Brown hair, guy1 Blue eyes, guy1 tall. Any help is
: appreciated!!!
: Mike
--------------------------------------
1. If you dont use link fields Then you would just have 1 table.
say, TableA.
Your sql will be:
select * from TableA where desc <> "skinny"
2. If your Table1 has fields guyname and guyid AND
Table2 has fields guyid and des
Your sql will be:
select guyname, des from Table1,Table2
where Table1.guyid = Table2.guyid AND
desc <> "skinny"
Raju Kallarackal