Suggestion fo SQL
"gio.cot via RPG400-L" <[email protected]>
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
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.