What is the query that will simply copy data from TableB fields into matching fields in Table A without having to use any WHERECLAUSES?
e.g.I dont need to copy the autonumber from tableB
TableA (table with no data) TableB (tablewith Data)
ID '<===Move data into tableA ID
CCon(Yes/No) CCon(Yes/No) ,_---True/False
Flow (Decimal) Flow (Decimal)