Forum Discussion

Alex_Kim245's avatar
Alex_Kim245
Copper Contributor
Jan 25, 2022

Sql query

Could someone help me construct query to find location that only has HP in below table; vendor location HP       TX Cisco   TX Dell     TX HP      CA HP      WA Dell    WA HP     OR Cisco  O...
bake13's avatar
bake13
Icon for Microsoft rankMicrosoft
Jan 26, 2022

Hi Alex_Kim245 --

 

That query will only work on SQL Server and is incompatible with Access.  Unfortunately I do not know the Access-equivalent syntax and do not have Access available on which to test.  Take care.

Alex_Kim245's avatar
Alex_Kim245
Copper Contributor
Jan 26, 2022
I see. Thanks for your help!

Resources