B
briank
I would like to query my table to output [Name] and [Location] based upon the
presense of multiple entries in [Location]. In my example below, "Jones" and
"Smith" will output in my query since they were in [Location] in different
entries (Seattle and Cleveland). To compare: Lawson has two entries too but
they were the same so he will not show up on my query. Is this a good time
to use a subquery? TY Brian
[Name] [Location]
Jones Seattle
Smith Seattle
Lawson Annapolis
Jones Cleveland
Smith Cleveland
Lawson Annapolis
Desired Output
[Name] [Location]
Jones Seattle
Jones Cleveland
Smith Seattle
Smith Cleveland
presense of multiple entries in [Location]. In my example below, "Jones" and
"Smith" will output in my query since they were in [Location] in different
entries (Seattle and Cleveland). To compare: Lawson has two entries too but
they were the same so he will not show up on my query. Is this a good time
to use a subquery? TY Brian
[Name] [Location]
Jones Seattle
Smith Seattle
Lawson Annapolis
Jones Cleveland
Smith Cleveland
Lawson Annapolis
Desired Output
[Name] [Location]
Jones Seattle
Jones Cleveland
Smith Seattle
Smith Cleveland