SQL Join question

[Mark Smith]

Perfect, thank you.


Peter Haworth wrote
> but if there are three tables, the SELECT becomes:
> 
> SELECT tableA.*, tableB.*, tableC.* FROM tableA JOIN tableB ON
> tableB.
> <keycolumn>
> =tableA.
> <keycolumn>
>  JOIN tableC ON
> tableC.
> <keycolumn>
> =tableA.
> <keycolumn>
> But the keycolumn must have the same value for all three tables.





--
View this message in context: http://runtime-revolution.278305.n4.nabble.com/SQL-Join-question-tp4680574p4680597.html
Sent from the Revolution - User mailing list archive at Nabble.com.