Shipment Group (tbl)

From UG

Revision as of 23:57, 8 December 2009 (edit) Alex (Talk | contribs) ← Older edit		Current revision as of 08:46, 31 January 2010 (edit) (undo) Alex (Talk | contribs) m (moved Tbl Shipment Group to Shipment Group (tbl))
(4 intermediate revisions not shown)
Line 1:		Line 1:
-	[[Category:DB]]	+	[[Category:Shipment Data Objects]]
Line 14:		Line 14:
	4 rows in set		4 rows in set
	</pre>		</pre>
		+
		+	== Useful Queries ==
		+
		+	* selectAll
		+
		+	SELECT sg.Id AS Id, sg.MasterId as MasterId, tm.Id AS TransportModeId, tm.Mode AS TransportModeValue,
		+	cc.Id AS ClientCompanyId, cc.CompanyName AS ClientCompanyName
		+	FROM tblShipmentGroup sg, tblTransportMode tm, tblClientCompany cc
		+	WHERE sg.TransportModeId=tm.Id AND sg.ClientCompanyId=cc.Id
		+	ORDER BY Id;
		+
		+	* delete grp
		+
		+	DELETE FROM tblShipmentGroup WHERE Id= ...
		+
		+	*
		+
		+	SELECT Id AS Id FROM tblGenericShipment WHERE ShipmentGroupId = ... ORDER BY Id

---

Current revision as of 08:46, 31 January 2010

mysql> describe tblShipmentGroup;
+-----------------+---------+------+-----+---------+----------------+
| Field           | Type    | Null | Key | Default | Extra          |
+-----------------+---------+------+-----+---------+----------------+
| Id              | int(10) | NO   | PRI | NULL    | auto_increment |
| TransportModeId | int(10) | NO   | MUL | NULL    |                |
| ClientCompanyId | int(10) | NO   | MUL | NULL    |                |
| MasterId        | int(10) | YES  | MUL | NULL    |                |
+-----------------+---------+------+-----+---------+----------------+
4 rows in set

[edit] Useful Queries

• selectAll

  SELECT sg.Id AS Id, sg.MasterId as MasterId, tm.Id AS TransportModeId, tm.Mode AS TransportModeValue, 
           cc.Id AS ClientCompanyId, cc.CompanyName AS ClientCompanyName 
           FROM tblShipmentGroup sg, tblTransportMode tm, tblClientCompany cc 
           WHERE sg.TransportModeId=tm.Id AND sg.ClientCompanyId=cc.Id 
           ORDER BY Id;

• delete grp

DELETE FROM tblShipmentGroup WHERE Id= ...

SELECT Id AS Id FROM tblGenericShipment WHERE ShipmentGroupId = ... ORDER BY Id