Re: Help with select ??

[Steve Grosz]

Clarify:

I would want to search for PID from the vendor table, based on model name from the model table and spec info from the specs table.

So would it be:

select vendor.PID
from vendor
left outer join model
on vendor.PID=model.VendorID
left outer join specs
on model.Model=specs.ProdModel
left outer join url
on specs.ProdModel=url.ProdModel
where vendor.Vendor='#URL.Vendor#'

Something like that?