Select count

[jr_klein]

Hello!!!
I need help for this SQL command:
select (*) into nmb-reg from (select distinct TableA.fieldA, TableA.fieldB from TableA);

Thanks,

 

[knarf]

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.