sql server - SQL Subquery, Invalid Column Name -

sql server - SQL Subquery, Invalid Column Name -

tsql says : invalid column name 'vehicleid'

select (select dbo.vehicles.id dbo.vehicles bring together dbo.movements on dbo.vehicles.id=dbo.movements.vehicleid dbo.movements.id=dbo.alarms.movementid) vehicleid [dbo].[alarms] vehicleid =1

what problem ?

i think, looking this:

select alarms.* dbo.vehicles bring together dbo.movements on dbo.vehicles.id=dbo.movements.vehicleid bring together dbo.alarms on dbo.movements.id=dbo.alarms.movementid vehicleid =1

sql sql-server