SELECT car.vin as "VIN", manufacturer."name" AS "Manufacturer", model."name" AS "Model" FROM car, manufacturer, model WHERE car.vin = ? AND car.model = model.id AND model.manufacturer = manufacturer.id
NOTE: SQL code that is used in JDBC cannot contain a semicolon (";"). Semicolons in SQL code in other contexts are used to separate multiple statements. As a corollary of not allowing semicolons, SQL in JDBC must have only one statement.