too long

i have two table. first table name is A, second table name is B. then compare the two table with input data. input data bring data from 'A' table then check with 'B' table with the data then show the data when the data not in 'B' table.

You need to combine both tables using LEFT JOIN

SELECT  a.*
FROM    tableA a 
        LEFT JOIN tableB b
            ON a.colName = b.colName
WHERE   b.colName IS NULL

colname is the column that defines the relationship between the two tables.