sql - using NOT IN for multiple tables -


How do I simplify multiple 'no' questions? Is it able to use several subkeys: no (...) and no (..) and no (..)

I am using counting (sorry forgot about that Select the count from the company (visitor id) where the visitor id is not (select visitor id from userlog where actionID = 2) and visitor id (select visitor id from supply where product id = 4)

  select count from company C ( (Where the ID is not available) (where user ID is selected from *) where actionID = 2 and C.VisitorID = U.VisitorID) and do not exist (Select * from supply S where productID = 4 and S.VisitorID = U.VisitorID)  

Why does not exist? No: No strange visitor ID value has any meaning in user logs or suppliers

  • (left additive): Many outputs Rows if multiple user logs or Per VisitorID supplies.

  • Generally is not the only true option


    Comments