I have 2 tables.

"TABLE_A" has "TA_ID" field
The value in this field is 1 , 2 , 3 , 4 , 5 , 6 and 7

and

"TABLE_B" has "TB_ID" field
The value in this field is 1 , 2 , 3 and 8

TABLE_A.TA_ID different TABLE_B.TB_ID is 4 , 5 and 6 (follow to mathematics)

How to? i want to select that data in the SQL language by use SELECT command.

Thanks

So you like to select the data that is in table A but not in table B. Right?

SELECT DISTINCT ta_id
FROM table_a
WHERE ta_id NOT IN
(SELECT tb_id
FROM table_b);


It is possible that you can do it easier, but this works to.

Note that MySQL does not support subqueries, so unless you are using the latest alpha release, this will not work.

Hi,

You could try the following without subselects...

SELECT ta.id from table_a AS ta LEFT JOIN
table_b AS tb ON ta.id = tb.id
WHERE tb.id IS NULL;

This will display something like...

+------+
| id |
+------+
| 4 |
| 5 |
| 6 |
| 7 |
+------+
4 rows in set (0.00 sec)

cheers,
ash

Thank you asherh

Your script is correct. i tried that script.

If the TABLE_B have small records. This script is work.
But, if the TABLE_B have many records.
The script will be run long time so much.
and display "Fatal error: Maximum execution time of 30 seconds exceeded in"
it's over time.

Are there indexes on the 2 id columns?

No, The 2 id column are not primary and index.

What is a problem?