D
Deborah Najm
I am working with XBase backend data structures that cannot be changed. The
application is a data entry system, that is capturing the date a page was
entered and a unique id for the page. I can write a query to get to this
point
Sample Data
Query1 FLDNAME VALUE PAGE OCCURRENCE USER
TRDT01 10-APR-2006 1 1 X00000
TRDT01 10-APR-2006 1 1 X00001
TRID01 6 1 1 X00001
TRID01 1 1 1 X00000
TRDT01 12-APR-2006 10 1 X00000
TRID01 15 10 1 X00000
TRID01 19 10 2 X00000
TRDT01 12-APR-2006 10 2 X00000
TRDT01 12-APR-2006 11 1 X00000
TRID01 16 11 1 X00000
TRID01 20 11 2 X00000
TRDT01 12-APR-2006 11 2 X00000
TRID01 21 11 3 X00000
TRDT01 12-APR-2006 11 3 X00000
TRDT01 12-APR-2006 12 1 X00000
TRID01 18 12 1 X00000
TRID01 17 13 1 X00000
TRDT01 12-APR-2006 13 1 X00000
TRID01 22 13 2 X00000
TRDT01 12-APR-2006 13 2 X00000
TRDT02 10-APR-2006 2 1 X00001
TRDT02 10-APR-2006 2 1 X00000
What I need is to do some sort of union to get a table that would look like
this:
TRID TRDATE PAGE USER
1 10-APR-2006 1 X00000
6 10-APR-2006 1 X00001
15 12-APR-226 10 X00000
Any help would be greatly appreciated.
application is a data entry system, that is capturing the date a page was
entered and a unique id for the page. I can write a query to get to this
point
Sample Data
Query1 FLDNAME VALUE PAGE OCCURRENCE USER
TRDT01 10-APR-2006 1 1 X00000
TRDT01 10-APR-2006 1 1 X00001
TRID01 6 1 1 X00001
TRID01 1 1 1 X00000
TRDT01 12-APR-2006 10 1 X00000
TRID01 15 10 1 X00000
TRID01 19 10 2 X00000
TRDT01 12-APR-2006 10 2 X00000
TRDT01 12-APR-2006 11 1 X00000
TRID01 16 11 1 X00000
TRID01 20 11 2 X00000
TRDT01 12-APR-2006 11 2 X00000
TRID01 21 11 3 X00000
TRDT01 12-APR-2006 11 3 X00000
TRDT01 12-APR-2006 12 1 X00000
TRID01 18 12 1 X00000
TRID01 17 13 1 X00000
TRDT01 12-APR-2006 13 1 X00000
TRID01 22 13 2 X00000
TRDT01 12-APR-2006 13 2 X00000
TRDT02 10-APR-2006 2 1 X00001
TRDT02 10-APR-2006 2 1 X00000
What I need is to do some sort of union to get a table that would look like
this:
TRID TRDATE PAGE USER
1 10-APR-2006 1 X00000
6 10-APR-2006 1 X00001
15 12-APR-226 10 X00000
Any help would be greatly appreciated.