Many to Many Relations - Join?

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.

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

Code:

---

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

---

Hi slimdave,

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

Appreciate.

Quote:

---

Originally Posted by aph

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