Finding a particular record (1 Viewer)

[mumbles10]

This is a re-post... but my first post was vague... For Example if I have a join table like...

Company Plane City
Delta 1 London
Delta 1 Philly
Delta 2 London

and I wanted to find only Plane numbers that have been to London and London alone... so that would be plane 2... Can anyone shed light on how I could write a query to do that?

Thanks.

 

[Brianwarnock]

My 2nd post to your 1st thread explains how, my first post was incorrect, never post in a hurry.

Brian