Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excluding rows

Status
Not open for further replies.

esmedia

Programmer
Oct 1, 2000
2
DE
hi all,
i came up with this problem:

i have 3 tables:
Code:
create table questions (id ...);
create table users (id ...);
create table answers (question_id ..., user_id ...);

Code:
answers
contains all users' answers given to the questions (questions can be answered more than once by different users). i now want to select all questions which were ...

1) not answered at all
plus!:
2) not answered by a certain user

i'm too new to sql to find a solution (without subselects - because i have to use mysql here)

tia!
dieter [sig][/sig]
 
sorry - it should read:

... 2) already answered by a certain user [sig][/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top