Querying db for missing table row.

[Jolten]

Hi,

I want to query two tables in my database.

Table 1 is a list of images and artists (image #, artistuser, imagetitle).
When a user comments on one of these images Table 2 is updated with the username and comment (Image #, commentuser, comment).

I'd like to write a loop to display to the user every image in Table 1 that does not have a corresponding comment row in Table 2. I can work out the loop but I'm lost on writing the sql query where a row is nonexistant.

Basically I needsomething like:
where table1.image# = table2.image# and $bbuserinfo[username] does not exist in table2.commentuser

Is this possible?

Any help would be appreciated.