SQL = "select A.ibookID,A.list_book_id,A.title,A.content,A.HtmlFileDate,C.view_type,C.view_ok,C.view_size,C.view_showid from [NC_ibook] A inner join [list_view] C On A.list_book_id=C.view_id where A.ChannelID='" & ChannelID & "' And A.isAccept > 0 And A.ibookID=" & ibookidSQL_Dir = "select A.ibookID,C.HtmlFileDir from [NC_ibook] A inner join [NC_Classify] C On A.ClassID=C.ClassID where A.ChannelID=" & ChannelID & " And A.isAccept > 0 And A.ibookID=" & ibookID如何把NC_IBOOK,LIST_VIEW,NC_Classify 用一个SQL语句关联起来?
SQL = "select A.ibookID,A.list_book_id,A.title,A.content,A.HtmlFileDate,C.view_type,C.view_ok,C.view_size,C.view_showid from [NC_ibook] A inner join [list_view] C On A.list_book_id=C.view_id where A.ChannelID='" & ChannelID & "' And A.isAccept > 0 And A.ibookID=" & ibookidSQL_Dir = "select A.ibookID,C.HtmlFileDir from [NC_ibook] A inner join [NC_Classify] C On A.ClassID=C.ClassID where A.ChannelID=" & ChannelID & " And A.isAccept > 0 And A.ibookID=" & ibookID如何把NC_IBOOK,LIST_VIEW,NC_Classify 用一个SQL语句关联起来?
On A.ClassID=B.ClassID 就可以了;)雄关漫道真如铁 而今迈步从头越
A.ibookID,A.list_book_id,A.title,A.content,A.HtmlFileDate,C.view_type,C.view_ok,C.view_size,C.view_showid,C2.HtmlFileDir
from [NC_ibook] A
inner join [list_view] C On A.list_book_id=C.view_id
inner join [NC_Classify] C2 On A.ClassID=C2.ClassID
where A.ChannelID='" & ChannelID & "' And A.isAccept > 0 And A.ibookID=" & ibookid