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. _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
