What can MySQL use tbl_name.column_name ? Please provide examples of use or otherwise explain in which situations the indicated expression may be useful.

  • What do you mean? Your question is not clear. - Alexey Shimansky
  • 2
    Actually in any way and in any place where the column name can stand - Mike
  • @ Alexey Shimansky, examples of teams where used. - jisecayeyo pm
  • @Mike, what's the point? - jisecayeyo
  • one
    @jisecayeyo Meaning - if in the same query columns of the same table with the same name are used, that would be a clear column from which table in this place is meant - Mike

1 answer 1

like so

 SELECT tbl1_name.column_name1, tbl2_name.column_name1 FROM tbl1_name, tbl2_name WHERE tbl1_name.column_name2=tbl2_name.column_name2