legal101205

Posts

Reputation

Joined 15 Years Ago

Last Seen 14 Years Ago

0 Reputation Points

Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements

1 Contribution

Ranked #107.40K

Discussions / Questions x 1

~87 People Reached

Favorite Forums

Databases x 1

Foreign keys from one table to a parent field

15 Years Ago 15 Years Ago

I use the TableAdapter Configuration Wizard under VS2008 and use SQL Server Express. This is my database diagram: [URL="http://farm4.static.flickr.com/3076/2803435396_c35b6dc2a7.jpg?v 0"]Database structure[/URL] And this is my SELECT statement: [CODE]SELECT Parties.PartieID, Parties.RondeID, Parties.JoueurNoirID, Parties.JoueurBlancID, Parties.ScoreNoir, Parties.ScoreBlanc, Parties.VainqueurID, Parties.DetailVictoire, Rondes.Numero, Tournois.Nom, [B](SELECT Pseudonyme FROM Joueurs WHERE JoueurID = Parties.JoueurNoirID) AS JoueurNoir, (SELECT Pseudonyme …

Databases