Forums Ultimate UI for Windows Forms
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
Close
Matthew
195
SQL statement to combine records from 3 databases with no common key
posted

I have a situation where I have three table. They are Staff, CPA, and Partners. All three contain 3 character text initials, which is the primary key, and the onlly field.

I also have situations where I need to display all values in all 3 of these lists in a combo box.

SQL Merge seems to merge data *into* another table. I just want a view, so I don't have to dynamically maintain the Producers list.

Again, there is nothing to join on.

Any ideas?

Thanks!

Matt

Parents
No Data
Reply
  • 45049
    Suggested Answer
    posted

    Matt,

    Your database should provide you with a way to create a view that returns the union of all three tables.

    Alternately, you can use a DataReader to read data from the three database tables into a single .NET DataTable.

    This seems to be a general programming/database question, one which is not necessarily related to Infragistics controls.  I've moved this thread from the Windows Forms Application Styling forum to the WinCombo forum, because this is the best "fit" that I can find based on your description.

Children
No Data