Retrieving the rows...

[agvamsikrishna]

Hi,

here i am trying to retrive data from two tables where those two dont hv any type of relation.

can we retrieve the data from 2 table columns where both the columns have duplicate Values

Table1 Table2

Grouptitle Grouptitle (Both columns hv duplicate values)

i need to retrive the data from this two tables with out duplicate values.

pls help me in this regard..

Thanks & Regards
Vamsi Krishna.A.G

[ck9663]

Hi,

here i am trying to retrive data from two tables where those two dont hv any type of relation.

can we retrieve the data from 2 table columns where both the columns have duplicate Values

Table1 Table2

Grouptitle Grouptitle (Both columns hv duplicate values)

i need to retrive the data from this two tables with out duplicate values.

pls help me in this regard..

Thanks & Regards
Vamsi Krishna.A.G

are the records complete duplicate or just this fields?

[debasisdas]

try to use joins for the purpose.

Please pass on few more details for clear explanation.