VbzCart/queries/qryRpt Pkg Trx
Jump to navigation
Jump to search
<mysql>SELECT t.ID_Order, tt.Code, t.WhenDone, iif(t.ID_Package IS NULL,"","pkg #"&p.Seq&": ")&t.Descr AS Descr, t.Amount FROM (ord_trxact AS t LEFT JOIN ord_trx_type AS tt ON t.ID_Type=tt.ID) LEFT JOIN ord_pkgs AS p ON t.ID_Package=p.ID WHERE WhenVoid IS NULL ORDER BY WhenDone, Amount>0; </mysql>