[SOLVED] Joining SQLs together

[otuatail]

Can someone tell me how to extract records that I need for a mailing list. The first 3 are easy the last I can’t work out.

I need to recover any records that have dropped out of the system because of an invalid entry

Select * from Customers where Age < 21;

Select * from Customers where UK = true;

Select * from Customers where Special_Delivery = true ;

 

There could be a lot of queries. I need one that recovers all the remaining like

 

Select  * from Customers where where ..... Not covered by SQL1 ,SQL2 , SQL3

 

It would mean adding queries together.

 

TIA

 

Desmond.

 

 

[Mchl]

SELECT * FROM Customers WHERE Age <= 21 OR UK != true OR Special_Delivery != true

[otuatail]

Yes this would work but I might have to extend it. I thought I could copy a query inside another query. I have seen queries before with multipul SELECT statments in them like

 

WHERE (SELECT  * FROM ...)

 

The above could get very messy!

[shlumph]

SELECT * FROM Customers WHERE Age >= 21 AND UK != true AND Special_Delivery != true

 

However, I thought that boolean wasn't a valid SQL data type? What DB are you using?

[Mchl]

However, I thought that boolean wasn't a valid SQL data type?

 

It is not and it is at one time

SELECT true = 1, false = 0

[Mchl]

Yes this would work but I might have to extend it. I thought I could copy a query inside another query. I have seen queries before with multipul SELECT statments in them like

 

WHERE (SELECT  * FROM ...)

 

The above could get very messy!

 

I don't think so. Using subqueries for such simple task would actually be even more messy

 

WHERE
Customers.ID NOT IN (SELECT ID FROM Customers WHERE Age < 21)
OR
  Customers.ID NOT IN (SELECT ID FROM Customers WHERE UK = true)
OR
  Customers.ID NOT IN (SELECT ID FROM Customers WHERE Special_Delivery = true)

[otuatail]

Thanks alot that is what I was after.

 

Desmond.

 

[Mchl]

If it suits you...

 

It will be slower however (it runs four queries instead of one)