Duplication

[jeenajos]

Hi...
Im having 12 tables in a database.Record contain mobileno,place, date.
Records in one table will be duplicated in other. Wat query should i give to get unique mobileno in the whole 12 tables in the same format??

Pls help.
Thanks in advance.
Regards,
Jeen

[amitpatel66]

Hi...
Im having 12 tables in a database.Record contain mobileno,place, date.
Records in one table will be duplicated in other. Wat query should i give to get unique mobileno in the whole 12 tables in the same format??

Pls help.
Thanks in advance.
Regards,
Jeen

Please POST what you have tried?

[jeenajos]

select *
from
select y.mobileno,y.me ssage,y.languag e,y.place,y.cat egory,y.date,y. year
from yourTable as y INNER JOIN
(select mobileno, count(mobileno)
from yourTable
having count(mobileno) =1) as x ON y.mobileno=x.mo bileno

[amitpatel66]

select *
from
select y.mobileno,y.me ssage,y.languag e,y.place,y.cat egory,y.date,y. year
from yourTable as y INNER JOIN
(select mobileno, count(mobileno)
from yourTable
having count(mobileno) =1) as x ON y.mobileno=x.mo bileno

Could you please tell me if your query is working fine or not?
What is the problem you are facing in this query?