Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Query references same column twice
December 4, 2006, 7:19 am
rate this thread
I have a Table which lists people
id | Name
1 | Fred
2 | Bill
3 | Bob
And a second table which references two people from the first
id | Pship1 | Pship2
1 1 2
2 1 3
I would Like to make a query which Lists both names in each
Result should be
Fred | Bill
Fred | Bob
I've tried queries with Select as, and am having trouble with how to go
about referencing the same column in the peopledb twice.
Any help appreciatted.
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum