Shipment Group (tbl)

From UG

(Difference between revisions)
Jump to: navigation, search
(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
Personal tools