quote:

---

Originally posted by mjpr

Hi all,

I need some help with a query I have to build
I have 3 tables for make, model and version (cars):
TblMarcas (make)
TblModelos (model)
TblVersoes (version)

I filled 3 dependent dropdowns with the values from each table.
But now, I need to filter it a bit.
I need only to show makes that have certain types, lets say trucks and vans. And the model and version have to be dependent of the choice of the make.

The problem is, in the make table I have IDMake and MakeName;
in the Model: IDModel, Desc, IDMake;
and in Version: IDVersion, Desc, IDModel, IDSubGrupoVeiculo (truck, van,sedan,etc)

How do I do the drill down, showing only makes that have those types?

I've tried:


SELECT distinct m.IDMarca, m.NomeMarca FROM TblMarcas m, TblModelos mo, TblVersoes v
WHERE m.IDMarca = mo.IDMarca AND
mo.IDModelo = v.IDModelo AND
(v.IDSubGrupoVeiculo = '20' OR
v.IDSubGrupoVeiculo = '22' OR
v.IDSubGrupoVeiculo = '23' OR
v.IDSubGrupoVeiculo = '28')

but with no luck.

Please help



---
Mário Ramos

---

select t.NomeMarca  
from TblVersoes tv
left join TblModelos TM on tv.IDModelo = tm.IDModelo
left join TblMarcas t on t.IDMarca = tm.IDMarca 
where IDSubGrupoVeiculos = 4
group by t.NomeMarca

quote:

---

Originally posted by dinakar

Something like this: ?

select t.NomeMarca  
from TblVersoes tv
left join TblModelos TM on tv.IDModelo = tm.IDModelo
left join TblMarcas t on t.IDMarca = tm.IDMarca 
where IDSubGrupoVeiculos = 4
group by t.NomeMarca

Dinakar Nethi
SQL Server MVP
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

---