Field Name Attribute Name
STAT_DT statistical date
CUST_NO customer number
RECNT_1D_BUY_CGB_CHREM_PROD_DT buy our bank financial products for the latest day date

Such as this list
Want to extract data from other tables now insert the table of the third field, requires the following
1, valet financial management:
According to the customer number associated T5 CUST_NO, filter business code BUSI_CODE for (122: purchase; Last day 130: subscription), get the confirmed date of T5. ACK_DATE
2, structured deposits:
According to the customer number associated M.C UST_NO, get the latest on coupon date VALUE_DT
More than 3, finance and structured deposits of two dates in recent day,
How to write

CodePudding user response:

First try to write a query result set
Should your need, is the union of data in two tables together, and then to Max

CodePudding user response:

reference 1st floor jdsnhan response:

first try to write a query result set
Should your need, is the union of data in two tables together, and then asked Max

There are so many other fields also need to insert, the union is a waste of resources