in the query:
`tbl_menu`.`fld_name` AS tbl_menu_fld_name
is used to create an alias for the `tbl_menu`.`fld_name`
instead of having to reference it as:
`tbl_menu`.`fld_name`
the alias renames the column in the result to:
tbl_menu_fld_name
Jason thank you for the reminder :) I figer that after a few mins; alias creating :P
//Morgan