urgent...please help with code

[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?

 

[dlbjr]

What database are you using?

 

[dlbjr]

INSERT INTO matches ( JockeyId, StableID )
SELECT jockeyselections.JockeyID, jockeyselections.StableID
FROM jockeyselections INNER JOIN raceresultsview ON
jockeyselections.JockeyID = raceresultsview.JockeyID;

 

[Joey Martin]

Thanks, but I figured it out.