Complex Query in QueryExpression in Microsoft CRM 2011
Hi, Here is tables and relation,QueryExpression statement afterwards. contact 1--->N new_ticket N --> N new_tour QueryExpression query = new QueryExpression() { EntityName = "contact", ColumnSet = new ColumnSet(new string[] { "contactid", "firstname", "lastname", "birthdate", "fullname" } ) }; Query Expression will execute the query against contact. For performance issue; do not retrieve any columns that we do