[RESOLVED] simple mySQL Left join question

[theknight]

SELECT * FROM friends_notices_types friend_nt 
                                     LEFT JOIN notices_types nt ON nt.id=friend_nt.notices_type_id
                                     WHERE friend_nt.friend_id=4 LIMIT 0,20 

I do not really understand this mysql query.

Are

friends_notices_types "friend_nt"
notices_types nt

Aliases for each table? They are not fields within each mysql table.

[Derokorian]

Yes Indeed they are aliases..

SELECT * FROM friends_notices_types friend_nt
LEFT JOIN notices_types nt ON nt.id=friend_nt.notices_type_id
WHERE friend_nt.friend_id=4 LIMIT 0,20

is the same as saying

SELECT * FROM friends_notices_types AS friend_nt
LEFT JOIN notices_types AS nt ON nt.id=friend_nt.notices_type_id
WHERE friend_nt.friend_id=4 LIMIT 0,20

[theknight]

Derokorian;10985611 wrote:

Yes Indeed they are aliases..

is the same as saying

Thanks