Code Comments
Programming Forum and web based access to our favorite programming groups.I usually use INNER JOIN to link tables together in a straight line, like a branch. Can I use it to link tables like twigs stemming off the branch. If so, do I use: SELECT TABLE1.FIELD, TABLE2.FIELD, TABLE3.FIELD FROM ( TABLE1 INNER JOIN TABLE2 ON TABLE1.FIELD =TABLE2.FIELD ) INNER JOIN TABLE3 ON TABLE1.FIELD=TABLE3.FIELD or if the join has to be in the middle: SELECT TABLE_1.FIELD, TABLE_2.FIELD, TABLE_3.FIELD, TABLE_4.FIELD FROM TABLE_1 INNER JOIN ( TABLE_2 INNER JOIN TABLE_3 ON TABLE_2.FIELD =TABLE_3.FIELD ) ON TABLE_1.FIELD=TABLE_2.FIELD INNER JOIN TABLE_4 ON TABLE1.FIELD=TABLE3.FIELD John
Post Follow-up to this messagePowered by vBulletin
Copyright 2000-2006 Jelsoft Enterprises Limited.