I’m trying to write a query to find what orders don’t have the wipes item; however, I’m having difficulty because I’m not very familiar with sql.
ORDER ID ORDER NUMBER ITEM ITEM ID
00FF6248 2404902 Sponge 87f5
00FF6248 2404902 Soap 4D1C
1F210331 2404905 Gloves 2fb0
1F210331 2404905 Paper 4dbb
1F210331 2404905 Bags ad1e
6112f371 2404904 Wipes B94A
6112f371 2404904 Detergent 62DF
6112f371 2404904 Soap 4D1C
I tried doing a query WHERE ITEM <> 'WIPES'
and GROUP BY ORDER ID
(not sure if that is the right path)but I’m still getting all the orders.
The desire outcome would be:
ORDER ID
00FF6248
1F210331
Hopefully someone can point me in the right direction. Thank you in advanced.