Wednesday, 29 August 2018

Adding a new field to the stored procedure and table, the procedure does not return any results

I recently added a Deleted column to my table and then wanted to add an additional where clause but now I'm not getting any results anymore (it returned results before I added the deleted column)

SELECT
    tblEquipment.*, tblUsers.*
FROM
    tblEquipment
INNER JOIN
    tblUsers ON tblEquipment.UserID = tblUsers.ID
WHERE
    (UPPER(tblUsers.Dept) = 'ASPIRE' OR UPPER(tblUsers.Dept) = 'DEVELOPMENT')
    AND (AssetType = 'WORKSTATION' OR AssetType = 'LAPTOP')
    AND (tblEquipment.Deleted != 1)
ORDER BY
    Username

thanks for any help

If Deleted is NULL for every record, your condition should be:
AND (tblEquipment.Deleted != 1 OR tblEquipment.Deleted IS NULL)

0 comments:

Post a Comment