This topic is locked

Join SQL example in manual, wrong?

10/3/2006 2:33:31 PM
ASPRunnerPro General questions
T
tuyojrc author

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],
UserName
From [Cars]
inner join users on cars.userid=users.id

Sergey Kornilov admin 10/3/2006

It selects Username field from Users table.