[thelist] SQL problem

Scott Schrantz scotts at rci-nv.com
Fri Aug 16 10:28:16 CDT 2002


> -----Original Message-----
> From: Kevin Stevens [mailto:kjs at ratking.co.uk]
>
> 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?

If you're actually using this line, there's a couple of syntax errors. You
need an ampersand and space before ORDER BY, and you need a semicolon at the
end.

("SELECT * FROM FaveList WHERE pkmatch = " & PKey &_
 " ORDER BY Primary_ID ASC;")

Or, if you're using Access you can cheat by using the Query Builder and
creating the query you want, then go to View>SQL View to let Access write
the SQL for you. That should give you a more correct INNER JOIN.

--
Scott Schrantz
work: www.rci-nv.com
play: www.computer-vet.com



More information about the thelist mailing list