SQL Join question

[divya navaneeth]

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_Smith at 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 at 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