Skip to main content
jael91407431
Level 3
January 8, 2018
Solved

"R.O" in SQL

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

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

Thank you.

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    ShrawanSaxena-1
    ShrawanSaxena-1Accepted solution
    Adobe Employee
    January 19, 2018

    As mentioned above "R0" is the alias which is generated automatically. As query is done here for Recipient table(NmsRecipient R0)  so it "R0".  if you query from Delivery table (NmsDelivery D0) it is "D0" and for broad log it is (NmsBroadLogRcp) "B0".

    Yes it is is best practice to use alias and most of RDBMS recommends this.

    You can find several articles on internet to know the benefits of using alias's .

    SQL Aliases

    View in thread

    3 replies

    james_icf
    james_icf
    Level 2
    January 8, 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.

    Translate
      jael91407431Author
      Level 3
      January 18, 2018

      Thank you so much for the reply. In addition, what does "RO" stand for?

      And is it best practice of RDMS to use "RO" as an alias?

      Translate
      ShrawanSaxena-1
      Adobe Employee
      ShrawanSaxena-1Adobe EmployeeAccepted solution
      Adobe Employee
      January 19, 2018

      As mentioned above "R0" is the alias which is generated automatically. As query is done here for Recipient table(NmsRecipient R0)  so it "R0".  if you query from Delivery table (NmsDelivery D0) it is "D0" and for broad log it is (NmsBroadLogRcp) "B0".

      Yes it is is best practice to use alias and most of RDBMS recommends this.

      You can find several articles on internet to know the benefits of using alias's .

      SQL Aliases

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...