[RESOLVED] header - line item query question

[ZeBula8]

typeinfo    invoiceNumber serviceOrder                                       
----------- ------------- ----------- 
40          123           W123a
44          123           W123b
40          124           W124a
44          124           W124b
40          125           W125a
44          125           W125b
40          126           W126a
44          126           W126b

what i would like to do is make a query that will return on ONE LINE the data that is contained with typeinfo of 40 and 44.

40 is the header and 44 is the line item.



So on ONE LINE returned it should look something like:

40 124 W124a 44 124 W124b


Is this possible? Thanks in advance.