Select query
Posted: Sun Apr 27, 2003 2:07 pm
Hello,
I have two tables: Authors(aut_id, aut_name) and books(b_id,aut_id,b_name)
How should i write my query in oder to display the aut_name from the table aut where there are no any book names under this aut_id.
Table: Authors
-----------------
1. Taub
2. Proakis
3. Paul gray
Table: Books
---------------
1. 1. C Techniques
2. 1. Networks
3. 2. DSP
Now when i run this query, i want to show only Paul gray.
Many thanks
I have two tables: Authors(aut_id, aut_name) and books(b_id,aut_id,b_name)
How should i write my query in oder to display the aut_name from the table aut where there are no any book names under this aut_id.
Table: Authors
-----------------
1. Taub
2. Proakis
3. Paul gray
Table: Books
---------------
1. 1. C Techniques
2. 1. Networks
3. 2. DSP
Now when i run this query, i want to show only Paul gray.
Many thanks