J
Joey Martin
Please, please help with me with this code. I thought I had it figured
out, but no such luck.
I have two tables, raceresultsview and jockeyselections.
In jockeyselections, I have jockey names and stableid, for example Pat
Day, stableid 1000.
In raceresultsview, I have jockey names, and placement.
I want to do something like this:
select * from raceresultsview where jockey in (select jockey from
jockeyselections). This works FINE, but I need to figure out how to grab
the stableid, too.
Each time there is a match, I want to insert the stableid and placement
into the table named winnings.
How do I get this to work?
out, but no such luck.
I have two tables, raceresultsview and jockeyselections.
In jockeyselections, I have jockey names and stableid, for example Pat
Day, stableid 1000.
In raceresultsview, I have jockey names, and placement.
I want to do something like this:
select * from raceresultsview where jockey in (select jockey from
jockeyselections). This works FINE, but I need to figure out how to grab
the stableid, too.
Each time there is a match, I want to insert the stableid and placement
into the table named winnings.
How do I get this to work?