I tested your code, and it didn't give me customer numbers that I wasn't expecting. However, in your FROM clause, there is nothing relating table1 to table2. This gives you a cross-join (a.k.a. Cartesian Product) when you execute it. A corrected version of this would be:
select table1.customerNumber from table1
where table1.customerNumber not in (select table2.customerNumber from table2)
This gives a correct result.
An alternative method for doing this type of result retrieval uses a LEFT JOIN like so:
left join table2
on table1.customerNumber = table2.customerNumber
where table2.customerNumber is null
Depending on the size of the tables and the indices on each table, it could give you superior performance.
Hi, I am a newbie in developing a website. i have tried to connect using mysqli conncetion
Here is my simple code.
// db.php code
//$con = mysqli_connect("localhost","root","","bakery"); ...