Having some trouble with Select statement for following situation :

TableA TableB TableC
priAid I Primary PriBid I Primary PriCid I Primary
priBid I Fieldb2 C Fieldc2 C
PriCid I Fieldb3 C Fieldc3 C
Fielda4 C
Fielda5 C

Table A has one-to-one relation to B ( priBid ), Table A has one-to-one relation to C ( priCid )

I need to select tableA.Fielda4,tableB.Field2b,tableC.fieldc2 into a single record. For example if the search criteria was WHERE tableA.priAid = 1

The problem I am running into is the JOIN, I tried creating view to see example SQL code but got error saying can not have one parent to more than one child

Thanks !! CB