Hi.

I decided to start learning about sql thru access, so i created a query, then looked at the code thru sql view, and then tried to duplicate it. However, i am stuck. Here is what i created thru access' normal query process.

Select ydsgame.comp, team.player, team.team
--if i understand correctly, this grabs the 3 fields that i wish to use

from team left join ydsgame on team.[player] = ydsgame.[player]
--this states that i wish to return both of the columns from the team table, then i am matching a field from team with a field from ydsgame,
then i am matching team.player with ydsgame.player

where (((ydsgame.comp)>=320))
--this is my primary criteria, which is that a row is to be selected if the value in the ydsgame.comp column is >=320

order by ydsgame.comp desc;
--and this takes the results and sorts them by descending order

so, the above code works fine, (that is, it returns ydsgame, player & team for any player with ydsgame .=320) since i created it with the query process. So i decided to replicate it manually, using two different tables.

Here is my attempt.

Select tds.td, ints.player, ints.ints
-- this is supposed to grab tds.td, ints.player & ints.ints

from ints left join tds on ints.[player] = tds.[player]
-- this is supposed to state that i want both the columns from ints, then i am matching a field from ints with tds, then i am matching ints.player with tds.player

where (((tds.td)>=20))
--this is my primary criteria, which is that a row is to be selected if the value in tds.td >=20

order by tds.td desc;
--and this takes the results and sorts them by descending order

However, the above code that i wrote gives a popup for parameter value for ints.ints. I want it to yield tds, ints & player for any player with tds >=20. I cannot see the difference between what i wrote manually and what access created when i used the normal query process.

Help would be greatly appreciated,
brian