SQL Query - Help Requested

[stretchy]

I have a simple query, or so I thought:

select table1.pid,
table1.tid,
from table1
LEFT JOIN table2 ON table1.tid = table2.tid
where table1.tid = '1'
and table1.pid <> table2.pid

What I am basically looking for is all the pid and tid records where the tid equals '1' in table1 and where the pid doesn't exist in table two.

If someone can point in the right direction it would be appreciated.

Cheers,
Stretchy

[khaldryck]

your query do what you ask, except when pid is empty in both table
maybe using "where table2.pid is NULL" will do

[stretchy]

Thanks for the post, unfortunately I tried that and it didn't work either.

If I could use a subselect in mysql it would look something like this:

select t1.pid, t1.tid
from t1
where t1.tid = '1'
and t1.pid not exist (select pid from t2 where tid='1')

But with MySQL I can not use this format yet, so I need some help getting the syntax properly written.

Cheers,
Stretchy

[stretchy]

select t1.pid, t1.tid,
from t1
LEFT JOIN table2 as t2 ON t1.pid = t2.pid
and t2.tid = '1'
where t1.tid = '1'
and t2.pid is null