MySQL complex query

Question

Hello stackoverflow community!

I'm having trouble creating a mysql query.

I have 2 tables:

1) vehicles(engine_id)

2) engines(id, power)

I need to select all the vehicles, whose engine's power is > than some value. Could you please help me with that ? Thank you!

Stefan H · Accepted Answer · 2010-12-19 11:10:32Z

1

    SELECT *
      FROM Vehicles
INNER JOIN Engines On Vehicles.engine_id = engines.id
     WHERE Engines.power > yourValues

answered Dec 19, 2010 at 11:10

Stefan H

6,6934 gold badges26 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

On MYSQL this will be the fastest.