Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Question

Status
Not open for further replies.

phish20002003

Programmer
Sep 5, 2006
99
0
0
US
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
fsm.png
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top