select s.SpecItem, s.Article,supermag.Rep_GetBarCode(s.article, -1) barcode, crd.Name, crd.MesAbbrev, crd.MeasUnitPrec, crd.Name GroupName, s.ItemPrice Price, s.Quantity QtyFact, s.TotalPrice SumFact, s.Quantity QtyAwait, s.TotalPrice SumAwait, s.Quantity QtyDeficit, s.TotalPrice SumDeficit, s.Quantity QtySurplus, s.TotalPrice SumSurplus from supermag.SMSpec s, supermag.SVCardName crd where 0=1