J jr_klein New Member Jun 2, 2004 #1 Hello!!! I need help for this SQL command: select (*) into nmb-reg from (select distinct TableA.fieldA, TableA.fieldB from TableA); Thanks,
Hello!!! I need help for this SQL command: select (*) into nmb-reg from (select distinct TableA.fieldA, TableA.fieldB from TableA); Thanks,
K knarf New Member Sep 22, 2004 #2 I always use INSERT into Table SELECT * from table2 or INSERT TableDes ( a, b, c) SELECT a, b, sum(c) from TableSrc Where f = 'City' group by a, b The trick I do is build a workable select statement then place a INSERT at the top of it.
I always use INSERT into Table SELECT * from table2 or INSERT TableDes ( a, b, c) SELECT a, b, sum(c) from TableSrc Where f = 'City' group by a, b The trick I do is build a workable select statement then place a INSERT at the top of it.
