> I need to do a join between the following tables

> A -> B

> B -> C

> A -> D

> A-> E

> I know how to do all the joins between A and B and A and D and A and E but

> how I do insert the join between

> B and C

> from A inner join B on A.key = B.key inner D on A.key = D.key inner join E

> on A.key = E.key

> Where does the B -> C join fit in here.

Anywhere after the A -> B join.

On Feb 18, 11:12 am, "Marcin A. Guzowski"

<tu_wstaw_moje_i

@guzowski.info> wrote:

> Hi Bill,

> > I need to do a join between the following tables

> > A -> B

> > B -> C

> > A -> D

> > A-> E

> > I know how to do all the joins between A and B and A and D and A and E but

> > how I do insert the join between

> > B and C

> > from A inner join B on A.key = B.key inner D on A.key = D.key inner join E

> > on A.key = E.key

> > Where does the B -> C join fit in here.

> Anywhere after the A -> B join.

> --

> Best regards,

> Marcin Guzowskihttp://guzowski.info

You can also add the condition at the end in a where statement.

Thanks

Mahesh

-----------------------------------------------**Reply**-----------------------------------------------

lucky wrote:

> You can also add the condition at the end in a where statement.

You're right but I think that's not a good idea to mix two joining

methods (explicit INNER JOIN and SQL:1989 WHERE style).

--

Best regards,

Marcin Guzowski

http://guzowski.info