Link to home
Start Free TrialLog in
Avatar of mcrmg
mcrmg

asked on

query question

Hi,

I have two sample tables, how can I come up with the result that shows everything from V and left 3, 5 in S as null

SELECT     v.vid, v.vname, s.sid, s.sname
FROM         service s LEFT  JOIN
                      visit v ON s.sid = v.vid
WHERE s.sid not in (3,5)

thanks
c1.JPG
c2.JPG
ASKER CERTIFIED SOLUTION
Avatar of Dustin Saunders
Dustin Saunders
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mcrmg
mcrmg

ASKER

is there another to do this?  thanks
Avatar of Dustin Saunders
Dustin Saunders
Flag of United States of America image
There might be, though this is the simplest route.  Is that not the result you needed?
Avatar of mcrmg
mcrmg

ASKER

thank you very much