SQL problem

Posted in 1997

Peter Marley — Wed, 19 Nov 1997 16:44:56 GMT — source: Informix-list mailing list archive (1991-1998)

I have to create a view that extracts its information from one table and generates one row in the view per invoice in the table. Is this possible in SQL? Example: Table has the following columns: invoice# line# cost type cost 00001 001 unit price 100 00001 001 cost of sales 200 Can I create the following view: invoice# line# unit price cost of sales 00001 001 100 200 Any help would be appreciiated, Thanks Peter __________________________________ Peter Marley DataBase Manager, Acco UK Ltd Tel: +44 (0)1296 397444 ext. 4098 Fax: +44 (0)1296 311019 email: peter.marley@acco-uk.co.uk