C# Programming
11-11-2009, 01:18 AM
table A Id Name
1 John
2 Mary
table B Id A.Id content
1 2 aboult Mary
2 1 aboult John
query:
Mary aboult Mary
John aboult John
name modified
table A Id Name
1 Mary
2 John
query again:
Mary aboult Join
John aboult Mary
The result is error!
How to design?
modified on Monday, November 9, 2009 9:46 PM
1 John
2 Mary
table B Id A.Id content
1 2 aboult Mary
2 1 aboult John
query:
Mary aboult Mary
John aboult John
name modified
table A Id Name
1 Mary
2 John
query again:
Mary aboult Join
John aboult Mary
The result is error!
How to design?
modified on Monday, November 9, 2009 9:46 PM