How to filter one database query by another

[DennisMcDougall]

What I am hoping to do is filter one database query by another. I have two
databases and they both have a field call vehicle_type. What I want to happen
is that vehicle_type from the products database filters what is shown from the
accessories database. These are my SQL queries SELECT * FROM products WHERE
id = %s', SELECT * FROM accessories WHERE vehicle_type='''; I think the
accessories query should look like SELECT * FROM accessories WHERE
vehicle_type=''$vehicle_type'; but I don't know how to give $vehicle_type a
value from the products database. Hope this makes sense, any help would be
greatly appreciated. Thanks Dennis :0)

[CMBergin]

Join the tables in a single recordset. A basic outline (don't use SELECT
*):

SELECT P.ProductField1, P.ProductField2, A.AccessoryField1,
A.AccessoryField2, etc, for all the fields you need
FROM products P INNER JOIN accessories A ON P.vehicle_type=A.vehicle_type
WHERE P.id=%s


"DennisMcDougall" <webforumsuser@macromedia.com> wrote in message
news:d0dv6i$g7t$1@forums.macromedia.com...

> What I am hoping to do is filter one database query by another. I have

two

> databases and they both have a field call vehicle_type. What I want to

happen

> is that vehicle_type from the products database filters what is shown from

the

> accessories database. These are my SQL queries SELECT * FROM products

WHERE

> id = %s', SELECT * FROM accessories WHERE vehicle_type='''; I think the
> accessories query should look like SELECT * FROM accessories WHERE
> vehicle_type=''$vehicle_type'; but I don't know how to give $vehicle_type

a

> value from the products database. Hope this makes sense, any help would

be

> greatly appreciated. Thanks Dennis :0)
>