---
schema_version: "1"
id: 9f570483077847fa9507c5647f16c6420ea441268e6ef3d38537804a667da413
title: Alias Notation
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/salesforce-soql-sosl/guides/soql-sosl/sforce-api-calls-soql-alias.md
canonical_url: https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-soql-alias.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: ce0408646453183ab315464a2cf86704eba53750768d1d304dd9906ee62ad99a
products:
  - SOQL and SOSL Reference
  - Platform Developer Content
---

# Alias Notation

You can use alias notation in SELECT queries.

<!-- otherprops: soql -->

```codesegment
SELECT count()
FROM Contact c, c.Account a
WHERE a.name = 'MyriadPubs'
```

To establish the alias, first identify the object, in this example a contact, and then specify the alias, in this case “c.” For the rest of the SELECT statement, you can use the alias in place of the object or field name.

The following are SOQL keywords that can’t be used as alias names: `AND, ASC, DESC, EXCLUDES, FIRST, FROM, GROUP, HAVING, IN, INCLUDES, LAST, LIKE, LIMIT, NOT, NULL, NULLS, OR, SELECT, USING, WHERE, WITH`