[thelist] SQL problem

Steve Cook steve.cook at evitbe.com
Fri Aug 16 07:36:00 CDT 2002


Hi Kev!

Give something like this a try:

"SELECT * FROM table1 JOIN table2 ON table1.primaryKey = table2.primaryKey
WHERE pkmatch =" & PKey & "order by Product_ID asc:"

Here's a page with a little more info on the different types of JOIN that
are available.

Mail me your actual code if you need more pointers.

.steve



> -----Original Message-----
> From: Kevin Stevens [mailto:kjs at ratking.co.uk]
> Sent: den 16 augusti 2002 14:24
> To: Evolt
> Subject: [thelist] SQL problem
>
>
> 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?
>



More information about the thelist mailing list