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!