Mike B wrote:
> INNER JOIN Biographies B ON B.UserID = U.UserID
>
> the things that i cant seem to find anywhere are the B, the B. and the U.
The B is a so-called table alias. It can also be written as (note the AS)
INNER JOIN Biographies AS B ON B.UserId = U.UserID
Sometimes it's only used as a shorthand for a table, but sometimes it is necessary when doing a self join or when joining the same table more than one time in the same query, e.g. as in
SELECT
P.name AS 'Employee',
M.name AS 'Manager'
FROM personel AS P
JOIN personel AS M ON M.id = P.manager_id;
Note that in the above query another type of alias is used: a column alias.
--
felix
Please use
BBCode to format your messages in this forum.