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?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!