SQL question

Posted in 2003

Demeis, Tony — Tue, 17 Jun 2003 12:18:47 — source: IIUG Forums & Mailing Lists

Hi, Here's my scenario. I have two table in a one-to-many relationship in IDS 7.31. Is there a way in SQL to unload matching rows where a row is consolidated. What I mean by that is explained in the example below. Table1 has row: A|B|C|D Table2 (many) has rows: A|B|X|Y|Z|1 A|B|X|Y|Z|2 A|B|X|Y|Z|3 I would like to create a file where by matching on A & B the following row is created: A|B|C|D|X|Y|Z|1|X|Y|Z|2|X|Y|Z|3 Thank you, Tony