Making two queries into one

[smig]

*** Edit ***

I have two queries that I want to combine into one (I want to have one Query only - to delete the first one)

The first one will select all PPL with Cellular phones

SELECT PPL_Phones.PPLID
FROM PPL_Phones INNER JOIN PPL ON PPL_Phones.PPLID = PPL.PPLID
WHERE PPL_Phones.SugTelephoneID=2    ' --- SugTelephoneID=2 ---> Cellular

The second one will use the first one to select all PPL with no Cellular phone

SELECT PPL.PPLID, PPL.Phone
FROM PPL LEFT JOIN PPLWithCellularPhones ON PPL.PPLID = PPLWithCellularPhones.PPLID
WHERE PPLWithCellularPhones.PPLID Is Null

What I need is a list of PPL that have no Cellular phone.
The phones list of PPL are in PPL_Phones table
Also in the PPL table I have the main phone of each person (PPL.Phone)

Thanks

 

[theDBguy]

So, one query gives you a list of all people with phones and the other those without. If we combine the two, what result did we want to see? All people with and without phones?

 

[The_Doc_Man]

You COULD get the results with something like

SELECT PPL.PPLID, NZ( PPL.Phone, "" ) AS PPLPhone
FROM PPL LEFT JOIN PPLWithCellularPhones
ON PPL.PPLID = PPLWithCellularPhones.PPLID
WHERE IIF( PPLWithCellularPhones.PPLID Is Null, "Not Cellular", "Cellular" ) AS PhoneType
ORDER BY PhoneType,  PPLPhone ;

This might do the job, though I'll bet there are nuances here that we don't understand yet. For instance, the "SugTelephoneID=2" part?

 

[smig]

You COULD get the results with something like

SELECT PPL.PPLID, NZ( PPL.Phone, "" ) AS PPLPhone
FROM PPL LEFT JOIN PPLWithCellularPhones
ON PPL.PPLID = PPLWithCellularPhones.PPLID
WHERE IIF( PPLWithCellularPhones.PPLID Is Null, "Not Cellular", "Cellular" ) AS PhoneType
ORDER BY PhoneType,  PPLPhone ;

This might do the job, though I'll bet there are nuances here that we don't understand yet. For instance, the "SugTelephoneID=2" part?

Thanks
Sug = Type (In Hebrew )
SugTelephoneID=2 --> Cellular

I did some edits to the post.
Hope it's more clear now

 

[smig]

So, one query gives you a list of all people with phones and the other those without. If we combine the two, what result did we want to see? All people with and without phones?

Thanks for looking at this.
I did some edits to the post.
Hope it's more clear now

What I need are the ones with no Cellular