sql question

[doobster]

What is the best way to accomplish this using the minimum number of sql queries.

I have two tables, one contains a banner id, link url, img url, etc.
The other table contains the banner id, user id, timestamp. The user id is the user who clicked the banner.

Now I want to select and format the banners from the first table. But I only want the rows returned to be rows that are not contained in the second table.

For example, user id 2 has clicked banner id 1. So when the query is executed banner id 1 should not be selected from the first table because it has already been clicked on.

My previous approached I just select all rows from the first table then performed a second sql query with the banner id returned from the first query. But this is too slow and uses too many sql connections.

Any help appreciated.

[barand]

Table1 left join table2 on bannerid and select the ones where table2.bannerid is null.

[doobster]

Ok that works for banner uniqueness. But it doesn't work for userids. In table 2 I am going to have the same banner id multiple times with different user id's who clicked it. So I also need to check for the user id not being equal to the current user I have in a variable.

[doobster]

Just like to note that I added an AND table2.userid!=$userid.

this does not work.

[barand]

have u tried

AND table2.userid=$userid

[Sxooter]

how about:

select from table1 except (select from table1 join table2 on (table1.bannerid=table2.bannerid) where table2.id=userid);