MYSQL query 2 tables

Placebo

I have 2 tables

A - some numbers
B - lots of numbers


How do i render/print numbers from B that are NOT in A
[so basically if A included unsubscribed users, and B includes all users, then i wanna print only opted in users]

[PHP]$queryString5 = "SELECT register.mobile, sms.mobile FROM register, sms WHERE sms.mobile != register.mobile";[/PHP]

that doesnt quite work.

NeverSayDie

As it happens, there's a "NOT IN" query in SQL that does exactly that, see here for info;
http://www.techonthenet.com/sql/in.php

Edit; you could alternatively use a LEFT JOIN;
http://www.w3schools.com/sql/sql_join_left.asp

Webmonkey

NeverSayDie wrote: »

As it happens, there's a "NOT IN" query in SQL that does exactly that, see here for info;
http://www.techonthenet.com/sql/in.php

Edit; you could alternatively use a LEFT JOIN;
http://www.w3schools.com/sql/sql_join_left.asp

Yup,

A little example:
Get a list of part names for which there is no current shipment

 
SELECT name
FROM parts
WHERE pno NOT IN (SELECT pno
                      FROM shipments)

Placebo

thanks guys, found it earlier

[PHP]$queryString5 = "SELECT register.mobile FROM register WHERE register.mobile NOT IN (SELECT sms.mobile FROM sms)";

[/PHP]

amen

just a pet hate but you have no order by clause on your sql statement.

drives me mad. Lead to inconsistent result orders from the same sp

mark renton

amen wrote: »

just a pet hate but you have no order by clause on your sql statement.

drives me mad. Lead to inconsistent result orders from the same sp

:rolleyes:

Jagera

amen wrote: »

just a pet hate but you have no order by clause on your sql statement.

drives me mad. Lead to inconsistent result orders from the same sp

There are multiple reasons why a sql query wouldn't need an ORDER BY.

OP's query wasnt an sp either.