Im Trying to run SQL Syntax on access. This is my database:http://postimg.org/image/jvjfy95zj/I want to get all the customers that have all the action channels butit gives me an error message.This is my code:SELECT C1.customer_id FROM Customers C1 WHERE not exists(SELECT channel_id FROM Channels Where category= (SELECT category_id FROM Channel_Categories WHERE category_name="Action")) MINUS (SELECT channel_id FROM Channels, Packages_Channels, Packages, Packages_customers, Customers.C2 WHERE Channels.channel_id= Packages_Channels.channel_id ANDPackages_Channels.package_id= Packages. package_id ANDPackages.package_id=Packages_customers.package_number AND Packages_customers.customer_id= C2.customer_id ANDC2.customer_id=C1. customer_id));
So i took only part of the code and tried to get all the action channels that customer 1 don't have:SELECT channel_id FROM Channels Where category= (SELECT category_id FROM Channel_Categories WHERE category_name="Action")MINUSSELECT channel_idFROM Packages_ChannelsWHERE Package_id IN(SELECT package_id FROM Packages WHERE package_id IN(SELECT package_number FROM Packages_customers WHERE customer_id=1));
And getting error message.The code before the MINUS works alone and the code after the MINUS works alone but when i add all together with the minuts it gives me a syntax error.Why is that?[url][/url][url][/url][url][/url][url][/url]
What's wrong with my MINUS syntax?
Posted - 2014-02-07 : 12:14:05
