Re: Combining two tables MYSQL

["paross1" <webforumsuser@xxxxxxxxxxxxxx>]

How about combining them, order by aa.assetActionType, then group by that field 
in the output?

 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 IN ('E', 'V')
 AND aa.assetActionID = (SELECT MAX(x.assetActionID) 
 FROM assetAction x
 WHERE x.assetActionAssetID = a.assetID
 AND x.assetActionType = aa.assetActionType)
 ORDER BY aa.assetActionType , a.assetID

 Phil