Mysql join and sum is doubling result

The way to get around this is to create inline views of your aggregates and join on the those results. SELECT R.title_id, R.revenue, R.cost, F.interest FROM (SELECT title_id, Sum(revenue) revenue, Sum(cost) cost FROM revenue GROUP BY revenue.title_id) r LEFT JOIN (SELECT title_id, Sum(interest) interest FROM fund GROUP BY title_id) f...Read more

Android 7.0 Nougat is released

The new version of Android, 7.0 – Nougat is released and will be available first to the Nexus devices and Android One devices. Features: Expanded emoji: 72 new emojis are added. Multi-locale support: Compatible apps will show information in the locale you choose. Our Pradakshinam app is supporting ml-In and...Read more

How to clear the browser cache for one web page.

The browsers cache a webpage on your machine when it is loaded, and on subsequent request show the data from the cache instead of requesting the server. You can instruct the browser to load the most recent version of the page from the server (called Hard Refresh) by the following...Read more