Hi I am trying to develop a car database which has three tables like Cars, Engines and Tyres. I wanted to make a search from an ASP.NET page for particular type of car. The car has fields like carid, carname the Engine has fields like engine number engine name and CarID , The Tyres have fields like Carid and TyreName.


My question is I want to write a query that searches for the kind of car but my query gives all the results of the same car name. I dont want all the results but I just want one row to be given called the primary with just one Car Name and itz respective features. How can I do that ??? I am looking for an optimal solution...


Thanks for ur help in advance