|
Re: How to display another data set values in Table [message #554574 is a reply to message #554432] |
Mon, 23 August 2010 15:12 |
|
Your set up is a little unclear.
I think you have:
DATASET 1
column 1
column 2
column 3
DATASET 2
column a
column b
And you want to see:either:
TABLE
Set 1 Column 1
Set 1 Column 2
Set 1 Column 3
Set 2 column B (where Dataset 2 column a = Dataset 1 column 3)
OR
TABLE
Set 1 Column 1
Set 1 Column 2
Set 1 Column 3
A single flag indicating whether any data exists in Dataset 2 for the current row of Dataset 1 (where multiple matching rows may exist in Dataset 2)
If it's the first, then you probably want to join the queries or the datasets. If it's the second, we'd need some more information on your comparison and criteria.
I think joining the queries might be the more efficient approach, but I have no idea how complex your two datasets are.
|
|
|
|
Powered by
FUDForum. Page generated in 0.02636 seconds