"R.O" in SQL

Avatar

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
jael91407431
Level 3

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.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 50
Employee
shrawans3153003
Employee

Likes

69 likes

Total Posts

150 posts

Correct reply

66 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Boost 50
Employee
shrawans3153003
Employee

Likes

69 likes

Total Posts

150 posts

Correct reply

66 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 10
View profile
shrawans3153003
Employee

18-01-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

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Level 2
james_icf
Level 2

Likes

9 likes

Total Posts

20 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
james_icf
Level 2

Likes

9 likes

Total Posts

20 posts

Correct reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
james_icf
Level 2

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.

Avatar

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct reply

0 solutions
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
jael91407431
Level 3

18-01-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?