In Vfp, I can do this:
Use MYTable1
Append from MyTable2
and MyTable1 and MyTable2 dont have to have exactly same columns (MyTable 2 will just not have the other columns from MyTable1)

In TSQL, if i do this:
INSERT INTO MYTABLE1 ( SELECT * FROM mytable2)

I get an error : Column name or number of supplied values does not match table definition.

Is there any way bypassing the error in SQL

Tia
Gerard