Skip to content

Instantly share code, notes, and snippets.

@jonezy

jonezy/RealGarageUsers.sql

Created March 17, 2014 13:27
Show Gist options
  • Save jonezy/9599179 to your computer and use it in GitHub Desktop.
Save jonezy/9599179 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
RealGarageUsers.sql
SELECT u.FirstName, u.LastName, u.Email, c.Vehicle, c.Step,c.Colour,c.Roof,c.Stripe,c.Interior,c.Packages,c.Colourline,c.Wheel,c.Trim,c.Options,c.OptionsPrice, c.ConfiguredPrice, c.ProvinceConfigured, c.CreatedOn
FROM Configurations c
JOIN [User] u on c.UserID = u.UserID
where c.UserID != '99999999-9999-9999-9999-999999999999'
order by c.CreatedOn DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment