Professional Connection

SELECT pros.*, prosNames.* FROM pros, prosNames WHERE prosNames.proId = pros.id AND prosNames.default = 'Y' AND pros.id = "AAAAAA"