SQL test

SELECT
   *
FROM TBL_EXAMPLE T1
JOIN TBL_EXAMPLE2 T2
 ON T1.PK1 = T2.PK2
WHERE
  T1.DEL_FLG = 0
  AND T2.DEL_FLG = 0
  AND T2.COL1 = 'TEST';