Skip to content
Advertisement

SQL Query to fetch a user without an associated service

I have the below data in a table. I am trying to fetch all the “Modem” users, who do not have an associated telephone service.

I want to see DeviceNumber B and D in my output. But above query is not returning expected results.

Advertisement

Answer

Hmmm . . . One method would be:

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement