Hi
I have a question regarding to sql query. Can any one do this.?

We have two tables tableA and tableB, In tableA there is 20,000 records and in tableB 8000 records present. All records in tableB are duplicate, i have a field "ipd_prod" that is either "bulk" or "prduct name" i want to check only "product name" . Some records of tableB is also present in tableA.

"I want to fetch that records which is not in tableB and `ipd_prod` <> (not ) "bulk" ." ?

what is the sql_query I write for that particular records.


Thanks and Regards
Praful.