SQL statement Issues
What does the bottom SQL query syntax mean as a and as B?
Why can A and b be used without definition?
Program code: Private Sub loadfilelist (ByVal strsubjectno asString, ByVal Strsubfolderno asString)
Dim MySQL asString
Mysql="SELECTRow_number () Over("&Hdffilelistorderby.value&") asRowNo, A.*, B.employeename asRevisername fromTblfilelist asA
Mysql+=" Left OUTERJOINTblmstemployee asB onA.reviserno=B.employeeno "
Mysql+="WHEREA.subjectno='"& Strsubjectno &"' andA.subfolderno="&Strsubfolderno
IfLblfilemgntitlechi.Text<>"Internal Download" Then
Mysql+=" andA.showinpublic='Y'"
EndIf
Try
Using Mysqlds asSqlDataSource=New SqlDataSource
Mysqlds.providername=Strdbtype
Mysqlds.connectionstring=Webconfigurationmanager.connectionstrings (Strcnntype&"DBBTA"). ConnectionString
Mysqlds.selectcommand=Mysql
Mysqlds.datasourcemode=Sqldatasourcemode.dataset
Dim My_args asNew DataSourceSelectArguments
Dim MY_DV asData.dataview=Mysqlds.Select(My_args)
Lvfilelist.datasource=My_dv
Lvfilelist.databind ()
EndUsing
Catch EX asException
Dim Strerr asString="The program error message is as follows"&"\ n"&Replace(Replace(Replace(Replace(Trim (ex. ToString ()), CHR (
Ten), ""), Chr (
-), ""), "\", "\\"), "'", "\'")
Scriptmanager.registerstartupscript (Me, Me.GetType (), "Alert", "Alert" ('"& Strerr &"'); ", True)
EndTry
EndSub
What does the SQL statement matter exactly mean?