ORACLE

select * from (
  SELECT
    fax01,
    XMLAGG(
      XMLELEMENT("record",
        XMLELEMENT("fax02", fax02),
        XMLELEMENT("fax03", fax03),
        XMLELEMENT("fax04", fax04),
        XMLELEMENT("faxud02", faxud02),
        XMLELEMENT("fax05", fax05),
        XMLELEMENT("fax051", fax051),
        XMLELEMENT("faj06", faj06),
        XMLELEMENT("faj18", faj18),
        XMLELEMENT("fax07", fax07),
        XMLELEMENT("faxud03", faxud03)
      )
    ).getClobVal() AS record
  FROM faw_file,fax_file,faj_file
  where faw01=fax01 and faj02=fax05 and faw04='M'
  GROUP BY fax01
)

MSSQL

select
shelfNum ,
cylNum,cUser from dbo.cyl_shelf_data
where shelfNum in ('!B13122080056','!B13122080058')
 FOR XML PATH('record'), ROOT('records');