CODEWITHSUNDEEP
sql
Alb
Alb

Reputation: 61

SQL query issue with condition

I have this query here:

SELECT formam.*, SMS_MONTIME1.IDTICKET, SMS_MONTIME1.MBYLLUR,SMS_MONTIME1.time_added
FROM formam 
LEFT JOIN SMS_MONTIME1 ON formam.ID = SMS_MONTIME1.IDTICKET WHERE SMS_MONTIME1.IDTICKET =''
    or SMS_MONTIME1.IDTICKET is null
    AND dyqani_pergjegjes=$dyqanip
ORDER BY formam.data_fillim DESC

The issue is, it worked fine but when i added the condition AND dyqani_pergjegjes=$dyqanip it no longer works, i don't get any error though, i just don't get the desired result.

Someone help please

Upvotes: 0

Views: 51

Answers (1)

Sabashan Ragavan
Sabashan Ragavan

Reputation: 738

This will prolly fix the problem: 

SELECT formam.*, SMS_MONTIME1.IDTICKET, SMS_MONTIME1.MBYLLUR,SMS_MONTIME1.time_added
FROM formam 
LEFT JOIN SMS_MONTIME1 ON formam.ID = SMS_MONTIME1.IDTICKET WHERE SMS_MONTIME1.IDTICKET =''
    OR (SMS_MONTIME1.IDTICKET is null
    AND dyqani_pergjegjes=$dyqanip)
ORDER BY formam.data_fillim DESC

What I changed is that I put brackets around

SMS_MONTIME1.IDTICKET is null AND dyqani_pergjegjes=$dyqanip

to ensure correct precedence of OR and AND.

Upvotes: 1

Related Questions