Re: 3 tables join

Nick wrote:
> 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

So what is the issue? Post your best attempt and we will guide you with a hint or two. First write the SELECT clause, then the FROM clause, and make your best attempt at the WHERE clause.

Post your version number and any error message you receive.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org