Нумерация строк запроса в access |
SELECT a.ID AS SpisID, (Left([a].[Nclaim],6) & " " & Right([a].[Nclaim],2)) AS NClaim, m.NPart, c.DProduction, Replace(Nz([d.ServiceID])," ","") AS ServiceID, Left([d].[DamageType],4) AS DamageType, d.RemovedPart, Replace(([m.V]),"V","*") AS [], m.MAmount, "RUB" AS Val, m.MDescription, m.Quantity, "" AS Prim FROM ((qdfAccount AS a LEFT JOIN qdfMaterial AS m ON a.ID = m.MMainID) LEFT JOIN qdfCarInfo AS c ON a.NClaim = c.NClaim) LEFT JOIN qdfDamage AS d ON a.ID = d.DMainID WHERE (((a.Spisana)<>-1) AND ((a.NClaim)<="470761/01")) ORDER BY a.ID;
http://www.sql.ru/forum/1115548/numeraciya-strok-zaprosa-v-access
| Комментировать | « Пред. запись — К дневнику — След. запись » | Страницы: [1] [Новые] |