MYSQL HAVING WITH INNER JOIN
Database
1
Posts
1
Posters
0
Views
1
Watching
-
using ASP.NET (C#.NET) ,try to get a result from two table s using below quary, SELECT Sum(tbl_user_earned.point_awarded) AS SumOfpoint_awarded, Sum(tbl_transaction_history.points_chash_exchange) AS SumOfpoints_chash_exchange FROM tbl_transaction_history INNER JOIN tbl_user_earned ON tbl_transaction_history.uid = tbl_user_earned.uid GROUP BY tbl_transaction_history.uid HAVING (((tbl_transaction_history.uid)=1)); i tryied to execute this using PHPMYADMIN but this not working ,i got below error #1054 - Unknown column 'tbl_transaction_history.uid' in 'having clause' -RAJITH ALWIS RAJITH ALWIS