Jump to content
Larry Ullman's Book Forums

Chapter 7: Performing Joins Syntax 'character Period' Preceding Fieldname


Recommended Posts

Up to this point in the book all references to tables and fieldnames have been spelt out in full. In this chapter the examples introduce a new format for the syntax:

SELECT m.message_id, m.subject, f.name etc

 

Whilst the code works as described I cannot find any description for the preceding character and period syntax or choice of character. An explanation would be very useful for me to better understand this process if anyone could provide it please.

Link to comment
Share on other sites

Sorry about the confusion! Earlier in the book or chapter you'll find a reference to AS, which creates an alias. So just after the bit you posted there will be something like `FROM messages AS m` which simply says "for the sake of simplicity, let's call this table 'm' in most of this query". Just can also create aliases for column names and the results of function calls. 

 

Hope that helps!

Link to comment
Share on other sites

  • 2 weeks later...
 Share

×
×
  • Create New...