[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