highnote
03-16-2008, 03:58 AM
I think I need the UNION command. Maybe someone can help?
For simplicity, here's a hypothetical database:
Table1 -- 3 fields (20,000 records):
PrimaryKey (1 through 20,000)
DateTrackRaceNumberProgramNumber
PowerRating
Table2 -- 5 Fields (5,000 records):
PrimaryKey (1 through 5,000)
DateTrackRaceNumberProgramNumber
Odds
SpeedFigure
PaceFigure
I want to match the PowerRating from Table1 to the matching horse in Table2.
Table1 has more records than Table2, but both tables share some common running lines which are given by the column DateTrackRaceNumberProgramNumber.
I've never used SQL. I wrote some VB code to merge the datasets, but it was going to take about a day to run it. I may want to run this fairly often. There must be a faster way to match the data.
Any suggestions appreciated.
For simplicity, here's a hypothetical database:
Table1 -- 3 fields (20,000 records):
PrimaryKey (1 through 20,000)
DateTrackRaceNumberProgramNumber
PowerRating
Table2 -- 5 Fields (5,000 records):
PrimaryKey (1 through 5,000)
DateTrackRaceNumberProgramNumber
Odds
SpeedFigure
PaceFigure
I want to match the PowerRating from Table1 to the matching horse in Table2.
Table1 has more records than Table2, but both tables share some common running lines which are given by the column DateTrackRaceNumberProgramNumber.
I've never used SQL. I wrote some VB code to merge the datasets, but it was going to take about a day to run it. I may want to run this fairly often. There must be a faster way to match the data.
Any suggestions appreciated.