SQL |
SELECT
brokers.brokerID,
brokers.officeREF,
brokers.hideBroker,
brokers.priority,
brokers.name_last,
brokers.name_first,
brokers.name_first + ' ' + brokers.name_last AS name_full1,
brokers.name_last + ', ' + brokers.name_first AS name_full2,
brokers.name_last + ', ' + brokers.name_first + ' (' + brokers.email + ')' AS name_full3,
brokers.jobTitle,
brokers.phone_work,
brokers.phone_mobile,
brokers.email,
brokers.brokerPassword,
brokers.brokerPassHash,
brokers.phoneNumber,
brokers.brokerBio,
brokers.brokerSEOURL,
brokers.brokerDirect800,
brokers.spotlightVideo,
brokers.randomSeed,
brokers.broker_locations,
brokers.brokerLevelREF,
brokers.lastLoggedOn,
brokers.yw_matchname,
brokers.iybaBrokerID,
brokers.iyba_Biography,
brokers.iyba_BrokerTitle,
brokers.iyba_Cell,
brokers.iyba_DisplayPicture,
brokers.iyba_Phone,
broker_level.levelValue,
broker_level.levelName,
userOffices.officeID,
userOffices.officeName
FROM
brokers
LEFT JOIN broker_level ON brokers.brokerLevelREF = broker_level.levelID
LEFT JOIN userOffices ON brokers.officeREF = userOffices.officeID
WHERE brokerID = 315
ORDER BY brokerID |