Hello, I want to divide value from storage 8544 by value from storage 8541
You can check this: http://vpx.pl/i/2014/07/18/storage.jpg
For example player Ackerman - in result I want to have 94/3 = 31
I tried
But I do not have idea how I can divide it.
I tried also
but:
#1242 - Subquery returns more than 1 row
Does anyone have an idea?
You can check this: http://vpx.pl/i/2014/07/18/storage.jpg
For example player Ackerman - in result I want to have 94/3 = 31
I tried
Code:
SELECT `name`,`key`,`value` FROM `players`,`player_storage` WHERE (`key` = 8541 AND players.id = player_storage.player_id) OR (`key` = 8544 AND players.id = player_storage.player_id)
I tried also
Code:
SELECT ((SELECT `value` FROM `players`,`player_storage` WHERE `key` = 8541 AND players.id = player_storage.player_id)/(SELECT `value` FROM `players`,`player_storage` WHERE `key` = 8544 AND players.id = player_storage.player_id)) as diff
but:
#1242 - Subquery returns more than 1 row
Does anyone have an idea?