SQL Join question

Mark Smith Mark_Smith at cpe.umanitoba.ca
Sun Jun 22 18:17:25 EDT 2014

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.

More information about the Use-livecode mailing list