Hi,
I can't write the query for you as I don't know your database structure.
Effectively, it needs to have a join to join the two tables together and then you need to tell the query to filter by URL Parameter. You can do this in the standard dreamweaver recordset behaviour.
This might help...
WSc78c5058ca073340dcda9110b1f693f21-799ba.html
Cheers
Ian