Mäklare

Categories
Animal | Application |Art | Artificial Intelligence | Business | Certification | Commerce | Computer - Hardware | Databases | Electronics | Engineering | Grammar | History | Intelligence | Internet | IT - General | Language | Magazine | Medical | Photographic | Networking| Programming | Security | Uncategorized | WWW

EBooks by prafulkr

Noeman GSM - E-Books


Full download


Posted: February 15th, 2008, 7:32am CET by prafulkr

Tags  [edit]

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.

Full download