Skip to content

Instantly share code, notes, and snippets.

@thePunderWoman

thePunderWoman/gist:3812253

Created October 1, 2012 14:50
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save thePunderWoman/3812253 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save thePunderWoman/3812253 to your computer and use it in GitHub Desktop.
Download ZIP
Vehicle
Raw
gistfile1.sql
select V.VehicleID, V.BaseVehicleID FROM
Vehicle AS V
INNER JOIN BaseVehicle ON V.BaseVehicleID = BaseVehicle.BaseVehicleID
INNER JOIN Year ON BaseVehicle.YearID = Year.YearID
INNER JOIN Make ON BaseVehicle.MakeID = Make.MakeID
INNER JOIN Model ON BaseVehicle.ModelID = Model.ModelID
INNER JOIN Submodel ON V.SubmodelID = Submodel.SubmodelID
WHERE Year.YearID = 2006 AND Make.MakeName = 'Honda' AND Model.ModelName = 'Element'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment