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 A1-C1 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! Gary

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 Where TblA.CustNo = TblB.CustNo AND TblB.OrderNo = TblC.OrderNo