Shipment Group (tbl)
From UG
(Difference between revisions)
(→Useful Queries) |
|||
Line 16: | Line 16: | ||
== Useful Queries == | == Useful Queries == | ||
+ | |||
+ | * selectAll | ||
SELECT sg.Id AS Id, sg.MasterId as MasterId, tm.Id AS TransportModeId, tm.Mode AS TransportModeValue, | SELECT sg.Id AS Id, sg.MasterId as MasterId, tm.Id AS TransportModeId, tm.Mode AS TransportModeValue, | ||
Line 22: | Line 24: | ||
WHERE sg.TransportModeId=tm.Id AND sg.ClientCompanyId=cc.Id | WHERE sg.TransportModeId=tm.Id AND sg.ClientCompanyId=cc.Id | ||
ORDER BY Id; | ORDER BY Id; | ||
+ | |||
+ | * delete grp | ||
+ | |||
+ | DELETE FROM tblShipmentGroup WHERE Id=:Id |
Revision as of 00:11, 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=:Id