Forget my earlier post, thought you were wanting to select not insert. John's INSERT...... SELECT is the way to do it.
Pete lcSQL Software On Jun 21, 2014 7:57 AM, "Mark Smith" <mark_sm...@cpe.umanitoba.ca> wrote: > I have two tables A and B, both with the same structure (about 50 columns > each). I would like to combine them into a single table (ie. rows from > Table > A followed by rows from Table B). Does anyone know of an SQL statement that > will do that? > > Thanks > > > > -- > View this message in context: > http://runtime-revolution.278305.n4.nabble.com/SQL-Join-question-tp4680574.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 > _______________________________________________ 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
