Skip to content
Advertisement

How to use INNER LEFT instead of EXCEPT?

I read that MySQL does not support EXCEPT, and the workaround is to use LEFT JOIN.

THIS IS MY QUERY:

Basically: Trying to find out the manufacturers that sell PCs but not laptops.

How can I convert this query with the LEFT JOIN? I got confused..

Table Computers:

Table Manufacturers Computers:

So since Manufacturer ID number 1 sells Laptop the result set should include only Manufacturer ID number 2.

Advertisement

Answer

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