[SOLVED] f.* Mean selecting all Querys or only the F?

[Gayner]

SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as cat_state, c.name as cat_name, c.description as cat_desc,
            c.image, m.member_name as mod_name, mr.desktop, m.member_id as mod_id, m.is_group, m.group_id, m.group_name, m.mid
            FROM ( ibf_forums f, ibf_categories c )
              LEFT JOIN ibf_moderators m ON (f.id=m.forum_id)
		  LEFT JOIN ibf_members mr ON (mr.id=f.last_poster_id)

 

When f.* Does that mean it's selecting all for only ibf_forums or for all the tables listed, ibf_members, ibf_categories, etc?

[ignace]

f is an alias for ibf_forums thus f.* is the same as ibf_forums.* and thus it selects all columns of that table.

[Gayner]

f is an alias for ibf_forums thus f.* is the same as ibf_forums.* and thus it selects all columns of that table.

 

ty sir