I have a property table and an image table.
I want this query to return all distinct properties and a thumbnail image. However some properties don't have thumbnail images and they
don't get returned by the query. If the imgid is null I still want to return the property. Not sure of how to do this. Thanks
ALTER PROCEDURE dbo.procGetPropertiesSelect2
SELECT tblProperty.PropertyID, tblProperty.SubmitPersonKey, tblProperty.SubmitDate, tblProperty.Active, tblProperty.PropName, tblProperty.StreetAddress1, tblProperty.Storage,
FROM tblProperty INNER JOIN
tblPropertyImages ON tblProperty.PropertyID = tblPropertyImages.PropertyKey
View Complete Post