[RESOLVED] only shows the manufacturers when there is vehicles by this manufacturer, how?

searain

my tables

manufcatures has the following fields

manufacturers_id
...

models has the following fields

models_id
manufacturers_id
....

vehicles has the following fields

vehicles_id
models_id

I want to select all the manufacturers that has vehicles belong to it.

How to write a simple mysql query for that?

Do I need a sub query for this statement? Roughly, how many (in persentage) hosting ISP supports the mysql version with sub-query now? If I have to use sub-query, will my client have troubles to find a hosting company supporting mysql with sub-query?

Thanks!

LoganK

 SELECT * FROM manufacturers WHERE models.manufacturers_id=manufacturers.manufacturers_id AND vehicles.models_id=models.models_id

...it works in MSSQL (or Access), it should work in MySQL!

searain

Thanks!

I think you mean

SELECT DISTINCT manufacturers.* FROM manufacturers, models, vehicles WHERE models.manufacturers_id=manufacturers.manufacturers_id AND vehicles.models_id=models.models_id

I don't think I need to worry about this sql's perfermance vs. using some kind subquery.

LoganK

Yeah, I probably did mean that. Most of my SQL (in Access) has been done with a treatment program's database, and as such I don't need to use relational table features so I'm a bit rusty when it comes to them...but I still got it pretty close 🙂

Glad to hear it worked out; remember us if you need any help!