"R.O" in SQL

Avatar

Avatar

jael91407431

Avatar

jael91407431

jael91407431

08-01-2018

Can any one explain what the "R.O" mean when we generate a SQL expression:

ro.png

...and does Adobe Campaign generate the "R.O" be default in every SQL interpretation.

Thank you.

View Entire Topic

Avatar

Avatar

james_icf

Avatar

james_icf

james_icf

08-01-2018

It is the alias. You see "FROM NmsRecipient R0" in the second line. The system is creating an alias for the table, NmsRecipient. It is a best practice to alias data sources but also helps to clarify a field name that may exist in multiple data sources being queried. It is the same as saying NmsRecipient.FirstName, NmsRecipient.LastName, etc...

I do believe that ACM will always alias tables. it would not always be R0. Especially when there are more than 1 table involved.