[thelist] SQL problem

[Kevin Stevens]

I want to display the results from a database that picks all the records
that match the primary key in another database and then displays them in
ascending order but I can't work out the right SQL statement. What I want is
something along the lines of...

("select * from FaveList where pkmatch =" &PKey "order by Product_ID asc:")

which doesn't work. How would I do this?

TIA

Kevin Stevens
kjs at ratking.co.uk