Re: Problem with SQL query :(

[Sebastian Maur]

Rick James Wrote:
-------------------------------------------------------
> Yes, I see that your original posting has no
> records with label=5.
>
> Let's see the whole SELECT statement.
>
> LEFT JOIN could have caused what you describe.


Sorry I ment 6 im just on phone, missclick

It was like:

SELECT id_marketplace FROM mpu AS a 
JOIN mpu AS b ON a.id_marketplace = b.id_marketplace
WHERE
a.label = 6 AND a.properties IN (5,35)
AND
b.label = 7 AND b.properties IN (7,8)

And it came

11
12
13
13



Edited 1 time(s). Last edit at 01/23/2014 01:25AM by Sebastian Maur.