Shipment Group (tbl)

From UG

Revision as of 23:57, 8 December 2009 (edit) Alex (Talk | contribs) ← Older edit		Revision as of 23:59, 8 December 2009 (edit) (undo) Alex (Talk | contribs) Newer edit →
Line 14:		Line 14:
	4 rows in set		4 rows in set
	</pre>		</pre>
		+
		+	== Useful Queries ==
		+
		+	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;

---

Revision as of 23:59, 8 December 2009

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

Useful Queries

  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;