[Resolved] Special MySQL query (not a regular join!)

[window2]

Here is a simple example of the set up:

Table1 (table name)
ID (field name in Table1)
name (field name in Table1)

Table2 (second table name)
name (field name in Table2)
answer (field name in Table2)

content of 2 tables:

Table1
ID: 1 name: Bob
ID: 2 name: Sally
ID: 3 name: Jane

Table2
name: Bob answer: yes
name: Sally answer: no

Here is the needed query:
I need to get all info on the people in Table1 based on the following...
WHERE Table1.name=Table2.name AND Table2.answer='no'...
that part is easy but now here is the part I can't seem to figure out...
OR name does not exist in Table2 yet.

I have it set up to create an entry in Table2 when updating Table1, but I need to be able to access the records from Table1 (as described above) in a list BEFORE that update and creation is performed.

I do not want any records from Table1 that have a matching record in Table2 where answer='yes'.

Anyone got any ideas?

[tomhath]

I didn't test this, but all you need is a LEFT JOIN. Something like this:

select Table1.name
from Table1
left join Table2
on  Table1.name=Table2.name
where Table2.answer='no'
  or Table2.answer is null

[window2]

Thanks, but it returns no results. It should return 2.
I have been trying all sorts of combo's in JOINs and UNIONs but con't seem to get the result I want.

[window2]

Problem solved by someone else

select t1.ID
, t1.name
from table1 as t1
left outer
join table2 as t2
on t1.name = t2.name
and t2.answer = 'yes'
where t2.name is null