Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Select Max (Last Update Date) from "FUSION"."IRC_JA_EXTRA_INFO" — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Select Max (Last Update Date) from "FUSION"."IRC_JA_EXTRA_INFO"

Received Response


Calling all SQL Experts:

Trying to select the most current record (based upon last_updated_date field) from table "FUSION"."IRC_JA_EXTRA_INFO" in a data model.

Content (required):

We are building an Orientation report using Data Models and need to pull in FINRA information which is stored in "FUSION"."IRC_JA_EXTRA_INFO". We have build a data set within our data model to pull in the FINRA records. We are using an outer join so that we do not drop folks that do not have an entry in the "FUSION"."IRC_JA_EXTRA_INFO". so far so go that seems to be working fine.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!