Aliasing Tables in Reports

Aliasing Tables in Reports

I'm trying to build a Query Table in Zoho Reports using my Zoho CRM data, and I'm running into this error: 

  Whenever a table alias is defined, kindly use table alias name before the respective columns used in SELECT query

I'm trying to create a query table that joins several aliases of the Contacts table to the Opportunities table.  For example, an Opportunity has a Primary Contact, a Referral Source, a Primary Liaison, and an Agent.  All four of these are represented in the Opportunities table by Contact Ids that are lookups on the Contacts table, and I need to be able to pull different information for each.  Here's a sample query highly simplified. 

Select 
      Opportunities."Amount", 
      Opportunities."Opportunity Name" 
      etc. 
      Contacts."Full Name",
      Referrers."Full Name", 
      Liaisons."Full Name", 
      Agents."Full Name"
From Opportunities LEFT JOIN Contacts on Opportunities."Contact id"=Contacts."CONTACTID" LEFT JOIN Contacts AS Referrers ON Contacts."CONTACTID" = Opportunities."Referral Source" LEFT JOIN Contacts as Liaisons ON Contacts."CONTACTID" = Opportunties."Primary Liaison" etc. 

Essentially, I need to alias the Contacts table four times, but I can't get it to alias even once!  

Has anyone else had this difficulty?  
    • Sticky Posts

    • What’s New in Zoho Analytics – September 2025

      Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded
    • Announcing Agentic AI - Ask Zia!

      We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.
    • Invitation-Based User Access in Zoho Analytics

      Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security
    • Zoholics Europe 2025: Your Ultimate Data Analysis (Zoho Analytics) Workshop Experience

      Why should you attend? This year, Zoholics Europe 2025 is putting data analysis centre stage. With a dedicated workshop designed to answer all your data-related questions, you’ll gain practical skills, real-time solutions, and expert insights that you
    • [Webinar] Evolving BI & Analytics in the Age of AI

      Artificial intelligence is redefining how data is collected, analyzed, and leveraged across industries. As businesses strive to become more agile and insight-driven, traditional BI and analytics must transform to meet new demands. AI-first organizations