«

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!

What database are you using?

--
dlbjr
Pleading sagacious indoctrination!

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


--
dlbjr
Pleading sagacious indoctrination!

Thanks, but I figured it out.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!