SELECT * FROM stock, colours WHERE stock.pid = 10 AND stock.stockid != 4 AND stock.colourid = colours.colourid GROUP BY stock.colourid ORDER BY colours.title
Why does it still return records with a stockid of 4? :'S If I change != to = then it will ONLY return that row. And I am confused and != is in the menu, the pointy-arrows do not work either
I do not know the answer to your problem, but I would not be entirely surprised if it was something to do with GROUP BY behaving in a way you didn't quite expect. Perhaps it's just me, but I swear it does different things every time I use it.