strsql = "SELECT(SELECT COUNT(s.computer_name)from PC_HD as s
where s.computer_name <= t.computer_name)as no, t.computer_name, t.user, dt.section_name
FROM Section_DT as dt INNER JOIN PC_HD as t ON dt.section_id = t.section_id order by
t.computer_name";
เอาไป run ใน access ผ่าน แต่ run ที่ vwdexpress มัน error ว่า
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
strsql = SELECT COUNT(s.computer_name) as computer_name , t.computer_name, t.user_, dt.section_name
FROM Section_DT dt,PC_HD s,table_name t
where dt.section_id = t.section_id
and s.computer_name <= t.computer_name
order by
t.computer_name