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, Tprices.close
FROM Tprices INNER JOIN Sprices ON Tprices.Stksym = Sprices.stksym;
When I run it, I get thousands of duplicates. When I look at the dataset mode when I am designing it, there are 184 records. Any suggestions about why I am getting all these excess records.
INSERT INTO Sprices ( stksym, mdate, Volume, High, Low, [close] )
SELECT Tprices.stksym, Tprices.mdate, Tprices.Volume, Tprices.High, Tprices.Low, Tprices.close
FROM Tprices INNER JOIN Sprices ON Tprices.Stksym = Sprices.stksym;
When I run it, I get thousands of duplicates. When I look at the dataset mode when I am designing it, there are 184 records. Any suggestions about why I am getting all these excess records.