String: SELECT * FROM cds.single WHERE `Listing Agent ID` = 'CMLS96004' UNION SELECT * FROM cds.multifamily WHERE `Listing Agent ID` = 'CMLS96004' UNION SELECT * FROM cds.commercial WHERE `Listing Agent ID` = 'CMLS96004' UNION SELECT * FROM cds.rentals WHERE `Listing Agent ID` = 'CMLS96004' UNION SELECT * FROM cds.lots WHERE `Listing Agent ID` = 'CMLS96004' UNION SELECT * FROM cds.condos WHERE `Listing Agent ID` = 'CMLS96004' ORDER BY `Listing Price` ASC Total: 1 SortBy: ORDER BY `Listing Price`