Unsupported Screen Size: The viewport size is too small for the theme to render properly.

I Want To Display Tracker Resolved By Users On Monthly Basis, Data In

forums forums SQLyog SQLyog Comments I Want To Display Tracker Resolved By Users On Monthly Basis, Data In

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #13385
      ammreddy1981
      Member

      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.

       

      Issues table

      tracker table

      users table

      project table

      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

    • #35424
      peterlaursen
      Participant

      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.

Viewing 1 reply thread
  • You must be logged in to reply to this topic.