quote:

---

Originally posted by Nitu

Hi,

I need to write a query where i have four different tables - (tables 1 to 4) to join to another table - (table5).

Based on the value of a particular field (lets say field4) in table5 the corresponding records are in those different four tables.

The relation b/n the five tables is like this,

Table5-field1 (pk)
field2
field3
field4

Table1 has one to many records with table5, though not all records but only those who have field4 = 1
Table1-field1
field21
field31

The same goes with the rest of the tables.

So can i write a query like this,

select * from table5
inner join on table1 when table5.field4 = 1 or inner join on table2 when table5.field4 = 2 or inner join on table3 when table5.field4 = 3
or inner join on table4 when table5.field4 = 4

So any suggestions on how to do the above.

Thanks a lot in advance,
Nitu

---