mysql 减号_尝试在MySQL中执行减号操作

I am trying to perform a MINUS operation in MySql.I have three tables:

one with service details

one table with states that a service is offered in

another table (based on zipcode and state) shows where this service is not offered.

I am able to get the output for those two select queries separately. But I need a combined statement that gives the output as

'SELECT query_1 - SELECT query_2'.

Service_Details Table

Service_Code(PK) Service Name

Servicing_States Table

Service_Code(FK) State Country PK(Service_Code,State,Country)

Exception Table

Service_Code(FK) Zipcode State PK(Service_Code,Zipcode,State)

解决方案

MySql does not recognise MINUS and INTERSECT, these are Oracle based operations. In MySql a user can use NOT IN as MINUS (other solutions are also there, but I liked it lot).

Example:

select a.id

from table1 as a

where

AND a.id NOT IN (select b.id

from table2 as b

where );