Hi Guys
I am writing the following query to insert data in tblpostroom from another table. Both the tables have same field names like Date1,582,1810.
Now If I run the following query then in the fields 582,1810 of tblpostroom , the data gets stored 582,1810 respectively for all the records. But in actual fields 582 and 1810 store different data.
I think I am doing something wrong in the query.Can anyone please help me to resolve this problem?
Query inserts wrong data in the table
I am writing the following query to insert data in tblpostroom from another table. Both the tables have same field names like Date1,582,1810.
Now If I run the following query then in the fields 582,1810 of tblpostroom , the data gets stored 582,1810 respectively for all the records. But in actual fields 582 and 1810 store different data.
Code:
INSERT INTO tblpostroom ( Date1, 582, 1810 )
SELECT Date1, 582, 1810
FROM Sheet1;
0 commentaires:
Enregistrer un commentaire