Re: Combining two tables MYSQL

["paross1" <webforumsuser@xxxxxxxxxxxxxx>]

Something like this?

 SELECT a.assetID,
 a.assetDescription,
 a.assetLocation,
 aa.assetActionID,
 aa.assetActionType,
 aa.assetActionResult
 FROM asset a
 INNER JOIN assetAction aa ON aa.assetActionAssetID = a.assetID
 WHERE aa.assetActionType = 'E'
 AND aa.assetActionID = (SELECT MAX(x.assetActionID) 
 FROM assetAction x
 WHERE x.assetActionAssetID = a.assetID
 AND x.assetActionType = 'E')
 ORDER BY a.assetID


 SELECT a.assetID,
 a.assetDescription,
 a.assetLocation,
 aa.assetActionID,
 aa.assetActionType,
 aa.assetActionResult
 FROM asset a
 INNER JOIN assetAction aa ON aa.assetActionAssetID = a.assetID
 WHERE aa.assetActionType = 'V'
 AND aa.assetActionID = (SELECT MAX(x.assetActionID) 
 FROM assetAction x
 WHERE x.assetActionAssetID = a.assetID
 AND x.assetActionType = 'V')
 ORDER BY a.assetID

 Phil