How to make Outer Join with Mysql

2005-04-12
2013-06-03
  • Dinesh Kumar
    Dinesh Kumar
    2005-04-12

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