SOQL join between two standard objects

Question

All i want to do is to retrieve information from two standard objects Account and Case. For I have tried joins(which later I found does not work with SOQL), relationships (which does not exist in my case. except for default relationship). Following is another attempt using sub query: (By default relationship I mean that Id in Account is same as AccountId in Case)

Select Phone,City__c,CreatedDate,Name, (SELECT Customer_Satisfaction_Level__c,Product_Category__c FROM AccountId__r) 
FROM Account;

Also, SOQL does not allow aliases which would have helped me as I am working with QlikView. Please Help!

P.S: i want names from account and the case detail from cases. hence, a join between the two.

Answer 1

You can try querying the Case object and using dot notation to get to the Account info:

SELECT Account.Id, Account.Name, Id, Description from Case

Answer 2

You need to use a correct child relationship name Cases

Select Id, Name, (Select Id, Description From Cases) 
From Account

Like the documentation says (Relationship Queries):

For parent-to-child relationships, the parent object has a name for the child relationship that is unique to the parent, the plural of the child object name. For example, Account has child relationships to Assets, Cases, and Contacts among other objects, and has a relationshipName for each, Assets, Cases, and Contacts.