RE: Suggestion fo SQL

Hi Gio,  

I'm not quite sure what you need.
You want to have the FT and OR in a single row and grouped per year and
month?

If so, you may try the following query:
With TFt as (Select *
              from MyTable
              Where Type = 'FT'),
     TOr as (Select *
              from MyTable
              Where Type = 'OR')
Select *
  from TFt full join TOr on TFT.Year = TOR.Year and TFT.Month = TOR.Month;

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization – Education – Consulting on IBM i
Database and Software Architect  
IBM Champion since 2020

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
"Train people well enough so they can leave, treat them well enough so they
don't want to. " (Richard Branson)
"Learning is experience … everything else is only information!" (Albert
Einstein)


-----Original Message-----
From: RPG400-L <rpg400-l-bounces-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org> On Behalf Of gio.cot
via RPG400-L
Sent: Thursday, 21 August 2025 18:40
To: 'RPG programming on IBM i' <[email protected]>
Cc: gio.cot <[email protected]>
Subject: Suggestion fo SQL 

Hi All

 

I have a table like this:

 

Type   Year   Month           Code            value

FT         2028    07                      000001             656,22

OR       2028    06                      000001             894,01

FT         2025    08                      000001             123,45

OR       2025    08                      000001             444,45

 

 

I would need to get this result with SQL

 

Type   Year   Month           Code            value            Type2 Year2
Month 2         Code2          Value2          

FT         2028    07                      000001             656,22
-            -            -                         -
-

-            -                         -                         -
-                         OR       2028    06                      000001
894,01

FT         2025    08                      000001             123,45
OR       2025    08                      000001             444,45

 

How could do that ?  (If is possible ??)

 

Thanks in advance

Gio 

 

 

--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: [email protected] To subscribe, unsubscribe, or
change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related
questions.


-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.