Thank you so much. Will check it out for sure, and post any additional questions I may have.

Can anyone give an example of how one would use a sub-item inside the Add data/edit additional data option the query activity?As per Adobe's documentation, the add sub-item option lets you attach computed data to the collection. This lets you select the additional data from the collection or define ...

Super, thank you guys.

Hi,Where can I view the logInfo(), results?

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?

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.

Super, thank you Serge. Will give it a try.Much appreciated,Jae

Hi,Can you create create AC databases and/or tables using SQL Commands? If so, how does one do so?

Hi,I'd like to throw this out the community to see the best response:I wish to create an ad-hoc table in our AC instance for the purpose of querying.From what I understand, I can either create a list or another table.A list is a temporary if a convenient way to query that contains data or entities (...

Can we create lookup tables that can be joined to the recipient data within the workflow?In other words, can we create temporary lookup tables within the workflow for reporting and/or analytical purposes?