评论会员:游客 时间:2012/02/07
选择*从表1中T1FULLOUTERJOIN表2T2的T1.COLUMN1=T2.COLUMN1在WHERET1.COLUMN1ISNULL或T2.COLUMN1是NULL
pashad
评论会员:游客 时间:2012/02/07
codeprelang="SQL"spanclass="code-keyword"SELECT/span*spanclass="code-keyword"from/spanresultspanclass="code-keyword"FULL/spanspanclass="code-keyword"OUTER/spanspanclass="code-keyword"JOIN/spanregistrationspanclass="code-keyword"ON/spanregistration.ID=result.registrationIDspanclass="code-keyword"WHERE/spanregistration.username=spanclass="code-string"'/spanspanclass="code-string""+TextBox1.Text+"'/span/pre/code
Anuja帕瓦尔多尔
评论会员:游客 时间:2012/02/07
U必须保持"userid"的两个表中的列codeprelang="SQL"spanclass="code-keyword"select/span*spanclass="code-keyword"from/spanregistationt1,resultt2spanclass="code-keyword"where/spant1.username=spanclass="code-string"'/spanspanclass="code-string""+TextBox1.Text+"'/spanspanclass="code-keyword"and/spant1.userid=t2.userid/pre/code
王子安东尼G
评论会员:游客 时间:2012/02/07
。特别强调的事实,这绝对澄清