SELECT T0.DocEntry,t0.docnum as 'Invoice No', --T0.[U_CustomersGRNNo],T0.[U_GRDate], M.[BeginStr] as 'Prerflix',T0.[NumAtCard], (SELECT Top 1 X.[County] FROM CRD1 X Where T0.CardCode = X.CardCode)as'County', T0.[DocDate],T0.[CANCELED], T0.[TaxDate], ...