Many to Many Relations - Join?

[aph]

Hi All, I have 2 tables with many to many relation, how I can join? please give me a simple example according to the below tables:

TABLE_A
ID
--
23
23
23
45
45
67

TABLE_A
ID
--
23
23
23
45
45
67

Thanks in advance.

[slimdave]

It depends what result you want. You could just join them, but you might be looking for ...

select ..
from
   (select distinct id from table_a) t1,
   (select distinct id from table_b) t2,
where
   t1.id = t2.id

[aph]

Hi slimdave,

need to select some columns from table_a and some from table_b. How it works?

Appreciate.

[tamilselvan]

Hi slimdave,

need to select some columns from table_a and some from table_b. How it works?

Appreciate.

Post the table definition, sample data, and your requirements.

Tamil