Quote:
Originally Posted by Davy
Sounds like a typical N:M relationship. That is best modelled with another database table that connects the two other tables.
|
Yes like the table "model_in_city" that he describes in his OP, which you would query with the SQL I wrote, although I would have called the table something like "model_city_rel" to make it obvious what it's for.