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 contains 0 replies, has 0 voices, and was last updated by  peterlaursen 3 years, 11 months ago.

  • 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.

You must be logged in to reply to this topic.