RE: The UNION makes us strong^H^H^H^Hcrazy

Ah, so it is. Thanks. -- Dave Weingart, Sr. Programmer/Analyst"I can call modules from the vasty Private Label Servicesdeep." -- "Why, so can I, or so can Voice: +1-516-682-1470any programmer. But will they run FAX : +1-516-496-3160

The UNION makes us strong^H^H^H^Hcrazy

In a further followup to my needing to combine colummns, I have the two following SELECTS that each work when I do them alone select empssn,paycode_1,payrate_1 from paympe where not paycode_1 = '000' select empssn,paycode_2,payrate_2 from paympe where not paycode_2 = '000' However, when I do sel

RE: Breaking table columns into separate rows

I'm going to be creating a printed report for the users using a report writing application (developed in-house by me, so I could,at some point, change it to do more t han it does, but there are only so many hours in a day) The table structure is not under my control; it's a legacy table structure

Breaking table columns into separate rows

I have a table that has a structure similar to this | KeyField | Attrib1 | Attrib2 | Attrib 3 | What I need to do for a report that I need to generate is break this into multiple rows, as | KeyField | Attrib1 | | KeyField | Attrib2 | | KeyField | Attrib3 | Key field is not unique, and obvio