Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

merge two tables/queries

I have 3 queries in the model..Empl,License and Oracle. Empl joined to Oracle like Empl.username and Oracle.loginID License joined to Empl with Empl.username and License.userID.Here ,License.userI...
Show and Tell
  • stretcharm's avatar
    stretcharm
    8 years ago

    If the Queries are a similar structure you can Append in Query Editor on the Home Tab.

    If they are not the same adjust them in the query editor first. Make the columns the same name and types the same.

    If you don't have a licence type for the oracle ones. Add a Custom Column with a value of "Oracle"

     

     

     

stretcharm's avatar
stretcharm
Icon for Memorable Member rankMemorable Member
8 years ago

If the Queries are a similar structure you can Append in Query Editor on the Home Tab.

If they are not the same adjust them in the query editor first. Make the columns the same name and types the same.

If you don't have a licence type for the oracle ones. Add a Custom Column with a value of "Oracle"