How to make Outer Join with Mysql

  • Dinesh Kumar

    Dinesh Kumar - 2005-04-12

    I m making reports with datavision but the problem i m facing is of outer join with Mysql.MySql doesn't have views, I have such requirement in my report which can be filled through outer join
    I m not getting how it can be solved.

    • Jim Menard

      Jim Menard - 2005-04-12

      DataVision only does "regular" joins right now. Without views, I do not think there is a way to do what you want. On the other hand, I am definitely NOT a database expert, so perhaps somebody more knowledgable can give you a more satisfying answer.

      If you join the DataVision users' mailing list, you could ask your question there and see if anybody else has come up with a solution for MySQL.


Log in to post a comment.