I am trying to pull data from 2 tables and put into a new table..
this is how my query looks..
INSERT INTO SAMPLE ( Collection_Date, Collection_Time, Method_Name, Comment_Station_Location, Comments_Use_Impairment_Status, Comments_Land_Use, Comments_Biota_Habitat, StationKey )
SELECT [PA...