SELECT A.IdAddress,
L.[Description] [Location],
I.BusinessName [Institution],
A.[Description] [Address]
FROM [QMEDIC].[Address] A
INNER JOIN [QMEDIC].[Institution] I
ON A.IdInstitution = I.IdInstitution
AND I.Annulled = 0
AND I.IdClient = 1
LEFT JOIN [QCOMMON].[Location] L
ON L.IdLocation = A.IdLocation
WHERE A.Annulled = 0
ORDER BY L.[Description], I.BusinessName;
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.