Simple Question

[yu217171]

I have two tables;a one-many relationship.

Table 1
1 2
1
2 3

Table 2
1 Susan
1 John
2 Judith
3 Paul

I need to display my results from table 1 as

Susan Judith
John
Judith Paul

How would I set up my join?

Keith

 

[yu217171]

Sorry typo ...

Table 2 should look like this

Table 2
1 Susan
2 John
3 Judith
4 Paul

Hence, results should look like

Susan Judith
Susan
John Judith

 

[JayKusch]

QUESTION: second item in row 2 of Table1 is a "1"

how do you know that "1 John" in Table2 and not "1 Susan"???


Thanks

J. Kusch

 

[JayKusch]

Sorry we must have just passed each other - LOL

Thanks

J. Kusch

 

[JayKusch]

Are each of the numbers in Table1 in seperate columns?

Thanks

J. Kusch

 

[yu217171]

Yes seperate columns ...

Keith

 

[yu217171]

Ok I found a way of doing it. I had to reference the same table twice while on one doing an inner join and the second instance of the table (has to be aliased) and performing a LEFT OUTER JOIN.

HTH with anyone else encountering this problem.

Keith