|
Re: UNION of 2 data sets or 2 values for a Parameter [message #1787393 is a reply to message #1787392] |
Thu, 24 May 2018 15:44 |
|
You need to be more clear about what you're trying to do. Are you trying to mix the results of two data sets or four data sets? A UNION is very different from an outer join. Perhaps you can describe your data sources, the columns of each set, and what you're trying to obtain as a result.
After that, we can discuss how to best use parameters in your query.
|
|
|
|
Re: UNION of 2 data sets or 2 values for a Parameter [message #1787408 is a reply to message #1787398] |
Thu, 24 May 2018 22:08 |
|
In order for you to have a join between the data sets, there has to be a common column and value they share. It sounds like you want to use a UNION query, which will resemble:
Select ID, Name, Date1, Date2, String1, String2 from Table1
UNION ALL
Select ID, Name, Date1, Date2, String1, String2 from Table2
UNION ALL
Select ID, Name, Date1, Date2, String1, String2 from Table3
Unless the Name value appears in all of your data sets - is that the case?
|
|
|
Powered by
FUDForum. Page generated in 0.03743 seconds