SELECT

          "Invoice Number",

          "Total (BCY)",

          "i'm creating clothing for my",

          "Account id"

FROM  "Invoices (Apliiq Inc)"

LEFT JOIN "Contacts (Apliiq Inc)" 

    ON "Contacts (Apliiq Inc)"."Customer ID" = "Invoices (Apliiq Inc)"."Customer ID"

LEFT JOIN "Accounts" 

    ON  "Accounts"."Account Id" = "CRM ID"

WHERE "Invoice Status"  = 'Closed'

I am trying to get all invoices (from zoho books) with their associated account id (from zoho crm)