5. Except Help Needed


#1

Help.
This is my code.

SELECT category FROM new_products EXCEPT SELECT category FROM legacy_products

This is the error.
Select the items in the category column that are in the legacy_products table but not the new_products table.
Even if it's on the same line. I just need help.
Thanks.
P.S: I'm using Chrome.


#2

@earth24,
And if you add a semi-colon-;
and change the format
like

select category 
from legacy_products
EXCEPT
select category
from new_products;

Select the items in the category column that are in the legacy_products table
select category from legacy_products

but not
except

the new_products table.
select category from new_products;


#3

Thanks! :grin:
That was helpful!


#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.