Query Problem

[rblundell]

Thanks to anyone in advance that can help. Your help is really appreciated!



Basically I'm building a database for a university assessment came across a big problem, cannot get my head around it at all.

I have a table called Service_TABLE with the price of each service on each car. I created a Query to display the highest service that was made on all the cars that were serviced. However it seems to display all the prices for every service on each car over and over again. Really stuck :|

Some useful screenshots below :

Query Design View : http://tinypic.com/r/2gybuxg/6
Query Result : http://tinypic.com/r/24dj3vq/6

What is wrong with this code??

SELECT MAX(Service_TABLE.Service_cost), Vehicle_TABLE.Vehicle_ID
FROM Service_TABLE, Vehicle_TABLE;

[RuralGuy]

You need a join in the query or you get a cartesian product.

[genesis]

can you attach your database with the tables and query that you state here?