ESSENTIAL: Understand Table Aliases

Please watch this video! (and if necessary, read the definition of ‘alias’)

Aliases, specified right after where the table name appears in the FROM section, help you clarify where the fields are coming from that you SELECT.

Otherwise, how would Zoho know if you are selecting the “Lead Source” from the Contacts or Deals module?

If you choose not to use table aliases, you would have to use the format “table name”.”column name” for every field in the SELECT section when you’re drawing from two or more tables. That is an option.