Hi Mark Smith, You just try this query "select A.col1,A.col2 etc ,B.col1,B.col2 etc from table A inner join table B on A.id=B.id"
On Sat, Jun 21, 2014 at 8:27 PM, 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 > -- Thank You Divya S Sathyan _______________________________________________ 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