[RESOLVED] Is it possible - LEFT JOIN with additional condition?

[2005]

Hello,

I am trying to replace 2 queries by 1, but don't know if it's possible:

$result=mysql_query("SELECT nickname FROM usertable WHERE id='$id'");

$result=mysql_query("SELECT expiration FROM blacklist 
WHERE blacklisted='$id' and blacklisted_by='to'");

I could use this query to check if user exists in blacklist table

$resultc=mysql_query("SELECT 
usertable.nickname, 
blacklist.expiration

FROM usertable left join blacklist on usertable.id = blacklist.blacklisted 
where usertable.id = '$id'
");

but the problem is that this $id may be blacklisted by many users and in blacklist table may be many rows where blacklisted='$id'. I need something like:

[FONT="Courier New"]...left join blacklist on usertable.id = blacklist.blacklisted and blacklist.blacklisted_by='$to'
where usertable.id = '$id'....[/FONT]

Is it possible in one query?

Thanks.

[johanafm]

Yes you can

[2005]

How?

[CoderDan]

how? you answered that in your original post with your red text...

[2005]

oops...

With red text I wanted to explain what I need. I even didn't try if it works.

Thanks.

[CoderDan]

heh no worries. nothing like people with questions that already provide the solution in the initial post. we need more problems like this to solve 🙂