Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › SQLyog Comments › I Want To Display Tracker Resolved By Users On Monthly Basis, Data In
This topic contains 0 replies, has 0 voices, and was last updated by peterlaursen 3 years, 11 months ago.
I want to display tracker resolved by users on monthly basis, data in four tables..How to write a query to get desired output..please help me.
time spent table
out put will be like this
Date Tracker User Time spent project
1-Jun-15 Bug Ramu 2 Quality
2-Jun-15 Feature Rama 1 Dev
3-Jun-15 Support Kiran 8 Nwk
You will probably need to JOIN tables to achieve this. Refer MySQL documentation on this https://dev.mysql.com/doc/refman/5.6/en/join.html.
SQLyog Query Builder fully supports JOINs. Refer http://sqlyogkb.webyog.com/category/185-query-builder.
You must be logged in to reply to this topic.