Table 3 [help ]access integrated query the database problem There are three table, students ① Register Table ② students unit managers information table, ③ operations is the information users submit. Table data is structured as follows ① [Tab_user] Such as username dwmc xuehao Second, the data is structured as follows [admin] Table Adminname dwmc etc. ③ [stu_work] following table data structure Stu_name stu_xuehao yuwen_work etc. ① table and the table ② dwmc field for students and administrators, said his unit, but the table ③ due to some reasons, there must be no units of information, only now realizing the unit administrator can view and modify the operating units of student functions related to the need to form a comprehensive three inquiries? For example : After making landfall session managers ( "dwmc") =rs ( "dwmc"), then the sentence should be in operation sgl how to write HTML table? Sql= "select * from [stu_work] where : : : : : :" After the how to write? ? Initial inquiries met so complicated, we do not know that the no-good halo : :! Please help me find Baidoa, hey 嘿~~~ PS : after landing operations can be submitted by students, and Table Table ③ ① the relationship between stu_name=username; stu_xuehao=xuehao, the students may be linked units and the caretakers of the bridge, where the students out through the flat, then compared with the unit managers, on the same show, not the show, but they will not write sgl words : : : :

Select W.*, U.dwmc U W inner join [Tab_user] from [stu_work] On W.stu_name=U.username and W.stu_xuehao=U.xuehao Where. . .

With dual blunt, I do not understand quick look! It rained, Please Please Let me talk about the bar : : : : : : : blush : Fang

WU is the alias table. ON table behind the linkages between, Finished.

[ Closed window ]