Select Issue

[tpp123]

Hi - I'm trying to include certain fields from a following record into query results, based on the values being stored in 2 of the fields. For instance, if table1 has 2 rows where everything is the same, except for the contents in 2 fields, I would want the results of the first row and those 2 fields from the second row to be displayed in 1 row.

Thanks in advance

 

[johnherman]

This really isn't just a DB2 situation. Try asking it in the ANSI-SQL forum for better visibility.
ANSI_SQL
javascriptpenindex(450,450,'

http://www.tipmaster.com/includes/refinfo.cfm?w=450&h=450')

==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity