0 - 5 of 5 tags for subquery

hello everyone.

 

i have an INSERT query with a subquery like this one:

 

SELECT 1

 

            FROM SD_CRM.D_INDIV_PREF DIP

 

            WHERE DIP.SITE = FPL.SITE

 

                AND  TRIM(DIP.ID_CLIENT) = TRIM(FPL.ID_CLIENT)

 

Hi All
I have two tables like below with sample data:
 
ACCNT_TABLE    |   REF_TABLE
   ID_COL            |     REF_COL
    123                  |     Desc_123
    100                  |     200_payout

Hi All,
I have scenario like below:

Requirement - Need to select ID values those are present ( hidden)  in DESCR column. But no joining condition in both the tables.
Query I have used -

I'm curious to see if there is a way to get period-to-date values (e.g. WTD, MTD, QTD, YTD) without using a CTE or subquery. Here is an example query using a CTE: