Shipment Group (tbl)
From UG
(Difference between revisions)
(→Useful Queries) |
m (moved Tbl Shipment Group to Shipment Group (tbl)) |
||
(2 intermediate revisions not shown) | |||
Line 1: | Line 1: | ||
- | [[Category: | + | [[Category:Shipment Data Objects]] |
Line 27: | Line 27: | ||
* delete grp | * delete grp | ||
- | DELETE FROM tblShipmentGroup WHERE Id= | + | 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