3 tables join

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