phish20002003
Programmer
So here are my two tables and report for an online query
Table 1
1 x
1 y
1 z
Table 2
1 y 0
1 y 2
1 y 3
1 y 4
1 y 5
1 y 6
1 y 7
1 y 11
1 y 12
1 y 16
1 y 18
1 y 23
1 y 24
1 y 25
1 y 26
1 y 27
1 y 29
1 z 0
1 z 4
1 z 6
1 z 7
1 z 11
1 z 12
1 z 16
1 z 17
1 z 18
1 z 19
1 z 23
Report
1 y 0
2
3
4
5
6
7
11
12
16
18
23
24
25
26
27
29
1 z 0
4
6
7
11
12
16
17
18
19
23
I'm linking column 2 on table 1 with column 2 on table 2. I'm trying to figure out how to pass x too the report making the top two lines:
1 x
1 y 0
Stumped. Any help would be appreciated. Thanks
-Phish
"Why do you need to think? Can't we just sit and go budumbudumbudum with our lips for a bit?" - Mostly Harmless
Table 1
1 x
1 y
1 z
Table 2
1 y 0
1 y 2
1 y 3
1 y 4
1 y 5
1 y 6
1 y 7
1 y 11
1 y 12
1 y 16
1 y 18
1 y 23
1 y 24
1 y 25
1 y 26
1 y 27
1 y 29
1 z 0
1 z 4
1 z 6
1 z 7
1 z 11
1 z 12
1 z 16
1 z 17
1 z 18
1 z 19
1 z 23
Report
1 y 0
2
3
4
5
6
7
11
12
16
18
23
24
25
26
27
29
1 z 0
4
6
7
11
12
16
17
18
19
23
I'm linking column 2 on table 1 with column 2 on table 2. I'm trying to figure out how to pass x too the report making the top two lines:
1 x
1 y 0
Stumped. Any help would be appreciated. Thanks
-Phish
"Why do you need to think? Can't we just sit and go budumbudumbudum with our lips for a bit?" - Mostly Harmless