Wednesday, 29 August 2018
Subscribe to:
Post Comments (Atom)
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
Deleted
is NULL
for every record, your condition should be:AND (tblEquipment.Deleted != 1 OR tblEquipment.Deleted IS NULL)
Hello Friends! I am Ramana a part time blogger from Hyderabad.
0 comments:
Post a Comment