Posted By
Alejandro Ramos Alvarez
02-09-2024 07:28
Found In
Community:
Pentaho
\
view thread
Hi, I have this sql query: SELECT ORIGIN_CONTRACT_ID, COUNT(*) FROM( SELECT ORIGIN_CONTRACT_ID, CREATED, NTYPE FROM BILLING WHERE NTYPE IN (1, 73) AND ORIGIN_ID = 2 AND EXTRACT(YEAR FROM CREATED) = '2023' AND CODE IN (SELECT TOKEN_ID FROM REQUEST WHERE ...
|