How to get values from both tables in Join in COQL query in Zoho API

How to get values from both tables in Join in COQL query in Zoho API


In this below query I can get value either from Deal Table or from Contact table. If I wanted data from both the table it is not working. Can you please help me with this. Thanks in advance.

{     "select_query": "select ,A.Deal_Name,B.First_Name,B.Last_Name, B.Created_By.id from Deals A Left Join Contacts B On A.Contact_Name.id =  B.id where A.id!=0" }