MySQL Forums
Forum List  »  PHP

Re: Problem with SQL query :(
Posted by: Sebastian Maur
Date: January 22, 2014 11:25PM

Ok, but thats exactly what I did before too, I took the WHERE with:


A.Label=5 AND a.properties IN(5,35)
AND
B.label=7 AND b.properties IN(7,8)

but it gives me something like this

11
12
13
13

Because he set the B condition true even if A is wrong?

Options: ReplyQuote


Subject
Written By
Posted
January 18, 2014 10:39PM
January 19, 2014 12:30PM
January 19, 2014 12:41PM
January 20, 2014 03:24PM
January 21, 2014 06:22PM
January 22, 2014 04:19PM
Re: Problem with SQL query :(
January 22, 2014 11:25PM
January 23, 2014 12:15AM
January 23, 2014 10:23AM
January 19, 2014 12:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.