Using joins with Access

April 7, 2009 at 15:46:24
Specs: Windows XP
I have a database which is Oracle, with an Access front end. I'm trying to determine if I can join multiple tables into a single row. The tables are...

Table A Link Table Table B Table C

A! A1-B1 B1 C1

A1-B2 B2


Is there a way to join all of those tables into a single record so it would look like....

A1 B1 B2 C1

Thanks for the help!


See More: Using joins with Access

Report •

April 9, 2009 at 08:23:26
Are there some common fields in these tables?
You need a common field between pairs of tables in order to join.

For example
TblA Customer
TblB Order
TblC OrderDetails

TblA and TblB both have a field CustNo
TblB and TblC both have a field OrderNo

So you could have a "single record" from all 3 tables by using

SELECT TblA.field1, TblA.field2, ,TblA.field3....TblA.fieldx,
TblB.field1, TblB.fieldy , TblB.fieldz,
TblC.field1, TblC.field2, TblC.fieldk
TblA.CustNo = TblB.CustNo AND
TblB.OrderNo = TblC.OrderNo

Report •
Related Solutions

Ask Question