Hi all! I think I need some help moving data from one table to another. Here is the scenario:
I have two tables, tblDetails (studentID,Name, Class.....) and tblPhysics (StudentID.....). Now, I want to SELECT StudentID from tblDetails WHERE Class = 1 (SELECT tblDetails.StudentID FROM tblDetails WHERE tblDetails.Class = '1') So this one I can do. But then, I want to INSERT the results of the above query into a table tblPhysics which has a column StudentID. How do I do this? Select values from one table and then insert them to another existing table. Please note that I want to insert the query results to an existing table (I tried to use SELECT INTO, but that will create a new table).
I will appreciate any help.