select with two joins to one table

[tonvaneck]

Dear sql users,

We are busy to create a simple select statement. In this select statement there are two joins to one tabel.

TblReaders
Name1_id name2_id
1 2
3 4


TblNames
Id Names
1 John
2 Mary
3 Edward
4 NN


The query must create next result:

Name1 Name2
John Mary
Edward NN

Knows someone a solution?

Thanks for reading.

Ton.

 

[Juice05]

Try this:

Select Names1.Names, Names2.Names From TblReaders
Inner Join TblNames Names1 On Names1.ID = TblReaders.Name1_id
Inner Join TblNames Names2 On Names2.ID = TblReaders.Name2_id

 

[tonvaneck]

Thanks juice05 but it doesn't work

 

[Juice05]

What doesn't work? Are you getting an error? Is the data incorrect?

 

[tonvaneck]

hello juice05,

we are using sqlserver 2000

The query gives an syntax error in the two joins

Ton.

 

[PHV]

tonvaneck, read your manual about alias and post in a sql server forum for sql 2000 issue.

 

[Juice05]

Try this:

Select Names1.Names First, Names2.Names Second From TblReaders
Inner Join TblNames Names1 On Names1.ID = TblReaders.Name1_id
Inner Join TblNames Names2 On Names2.ID = TblReaders.Name2_id

If you get an error, please give me the entire error message.

 

[tonvaneck]

thanks for the information

Ton.