tarek_ta2ta2
Tarek
- Local time
- Today, 06:08
- Joined
- Jun 8, 2008
- Messages
- 47
hope everyone doing well
i have two tables
one for Models ( Camry - Avalon - Corolla )
and one for SubModels (XL - GL - Sadaan)
How to make a query between these tables
i can make one to many --- but how to make many to many
for example The camry has the subnodel XL and the Avalon to has the sub Model XL
As brief every model has more than one Submodel
and every Submodel can be selected by more then one model
any ideas Please ....
i have two tables
one for Models ( Camry - Avalon - Corolla )
and one for SubModels (XL - GL - Sadaan)
How to make a query between these tables
i can make one to many --- but how to make many to many
for example The camry has the subnodel XL and the Avalon to has the sub Model XL
As brief every model has more than one Submodel
and every Submodel can be selected by more then one model
any ideas Please ....