Recent content by jctaylor

Taking out the inner join worked. Thanks a lot.

I tried that and it didn't work either. I am importing a csv file into a temp table and I have tried appending that but I still get all the extra records.

I have a table with prices that I want to update with the latest prices. I used the query design for append and I got this sql statement. INSERT INTO Sprices ( stksym, mdate, Volume, High, Low, [close] ) SELECT Tprices.stksym, Tprices.mdate, Tprices.Volume, Tprices.High, Tprices.Low...