HI!
I am new in DB so I need some advices for finding the right solution.
I need to be able to make automatically any join between tables which the user choose and deliver the result.
is like making an hierarchy between all tables in DB (parent-child) and then making the select statement for the right join.
if u have any idea about how can I manage this, pls help me.
thanks a lot!I would start by getting a beginner sql server programming book.|||Automatically? You will need to define all your table relationships, and then write code that will will dive into the system tables to find these relationships.
Not an easy coding challenge.
I suggest you look for third party software that will do this, as I suspect that you are reinventing the wheel.
No comments:
Post a Comment