VbzCart/queries/qryRpt Pkg Trx - Revision history

Woozle: well, that was easy.

2011-06-01T23:39:21Z

well, that was easy.

← Older revision		Revision as of 23:39, 1 June 2011
Line 9:		Line 9:
	tt.Code,		tt.Code,
	t.WhenDone,		t.WhenDone,
	~~iif~~(t.ID_Package IS NULL,"","pkg #"&p.Seq&": ")&t.Descr AS Descr,		CONCAT(IF(t.ID_Package IS NULL,"",CONCAT("pkg #",p.Seq,": ")),t.Descr) AS Descr,
	t.Amount		t.Amount
	FROM (		FROM (

Woozle: tidied up but still not converted to MySQL

2011-06-01T23:33:08Z

tidied up but still not converted to MySQL

@@ Line 1: / Line 1: @@
-<mysql>SELECT t.ID_Order, tt.Code, t.WhenDone, iif(t.ID_Package IS NULL,"","pkg #"&p.Seq&": ")&t.Descr AS Descr, t.Amount
+==About==
-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
+* '''Requires''': {{vbzcart|table|ord_trxact}}, {{vbzcart|table|ord_trx_type}}, {{vbzcart|table|ord_pkgs}}
 WHERE WhenVoid IS NULL
-ORDER BY WhenDone, Amount>0;
+ORDER BY WhenDone, Amount>0;</mysql>
-</mysql>
+<section end=sql />

Woozle: SQL from MS Access -- not tested on MySQL yet

2011-06-01T23:27:08Z

SQL from MS Access -- not tested on MySQL yet

New page

<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>