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
Post a Comment