Shipment Group (tbl)
From UG
(Difference between revisions)
(→Useful Queries) |
(→Useful Queries) |
||
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 |
Revision as of 00:27, 9 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
- 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