Skip to content
  • Obidos Technologies (P) Ltd
Obidos Technologies (P) Ltd

ObidosTech Knowledge Base

Help snippets on NodeJs, React, ColdFusion, PHP, Android, iOS and tech news

About Obidos Technologies (P) Ltd

Profile
ObidosTech

Obidos Technologies (P) Ltd is an off-shore development and maintenance center for ColdFusion applications, PHP application along with ReactJS, NodeJS

Menu
  • Obidos Technologies (P) Ltd
  • Prasanth Kumar.S

Tag: answer

1 Articles
Categories
Database MySQL

Mysql join and sum is doubling result

August 23, 2016August 23, 2016
1 min read
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,…
Read more