>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
Try putting TableA in the middle: e.g.
select tableA.Fielda4,tableB.Field2b,tableC.fieldc2 ;
from tableB join tableA ;
join tableC ;
on tableA.priAid = tableC.tableA_id ;
on tableB.tableA_id = tableA.priAid ;
where tableA.priAid = nPrimaryKeyVariable
Insanity: Doing the same thing over and over and expecting different results.