Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
in the example of joining tables..... why is UserName in between [UserID] and From [Cars] .... what does it do? Modify it the following way:select Cars.[ID],[Make],[Model],[UserID],UserNameFrom [Cars]inner join users on cars.userid=users.id
It selects Username field from Users table.