3 tables join

Giganews Newsgroups
Subject: 3 tables join
Posted by:  Nick (nachiket.shirwalk…@gmail.com)
Date: Thu, 08 Nov 2007

I have have 3 tables TableA, TableB and TableC. TableA holds the keys
to TableB and TableC. I need a query which will display the details
from TableB and TableC depending on the key in TableA.

For eg.

TableA - columns {id, relatedkey, recordType} ===recordType will hold
values like TableB or TableC
TableB - columns{id, column1}
TableC - columns{id, column1}

the query should match the related key to the id of TableA or table B
based on recordType and show the column1 value with the TabelA id so
output for this should be

id    recordType      column1

1      TableB            value of TableB column1
2      TableC            value of TableC column1

Please help.

Cheers
Nick

Replies