Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
105
Relation between tables using mySQL Datasource
posted

Hello,

nowhere I found some information about using Database Table relations

I have the following two tables in the mySQL Database:

tableCar:
ID  Typ        User
-----------------------
1   Mercedes  2
2   Audi         1
3   Honda      2

tableCarUser:
ID  Name
-----------------------
1   Martin
2   Bill
3   Bobo

I would like to create the following table in my dasboard:

Car         User
------------------------
Mercedes  Bill
Audi         Martin
Honda      Bill

How can this be done?

Is it possible to have relations between tables or do I have to create a DB View for this?

Thanx, best Regards,

   Martin

Parents
No Data
Reply
  • 9490
    Verified Answer
    Offline posted

    Hi Martin,

    Thank you for being our customer!

    In the current version yes, you need to create a DB View. In the next version you will be able to do a join at ReportPlus, though this may not be the best in terms of performance for mySQL.

    Does this answer your question?

    Please don't hesitate posting back should you need more help.

    Take care,

Children