Select Max (Last Update Date) from "FUSION"."IRC_JA_EXTRA_INFO"
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.
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.