Getting data from 2 tables.

[jonniejoejonson]

Table A

Table B

 

Both table A and table B have a field: fileId

 

I want to select the fileId’s that are in table B, but not if they are also in the following SELECT result set from table A

 

SELECT fileId FROM a WHERE filetype=‘jpg’;

 

I hope you understand… I have only just grasped the concepts of joins but I’m at a loss as to how to do this?… Any help would be much appreciated…

 

Alternatively is there a way to create a new field on the fly so that when I am looping through the second sql result set there is field that says fileId is in both table B and also in the tableA sql result set….

 

kind regards J

[jonniejoejonson]

Thanks to Subdee from another forum for the answer...

 

SELECT b.fileId FROM tableB b

WHERE b.fileId NOT IN

(SELECT a.fileId FROM tableA a WHERE filetype='jpg')

AND filetype='jpg'