ÇóÒ»¸ösqlÓï¾äµÄд·¨\È¥³ýÖظ´Ïî

SQL code:
"SELECT top 8 dbo.jobs.CurrentName AS currentName, dbo.person.userid as xuserid," +
" dbo.company.*, dbo.person.*,dbo.companyyp.* " +
" from dbo.person INNER JOIN" +
" dbo.companyyp ON dbo.person.userid = dbo.companyyp.personid INNER JOIN"
+ " dbo.jobs ON dbo.companyyp.jobid = dbo.jobs.id INNER JOIN"
+ " dbo.company ON dbo.jobs.companyid = dbo.company.userid where person.Person_GraduateSchool='xxʦ·¶´óѧ' order by person.lastlogin_time desc";

--ÒòΪÊǶà±í²éѯ,ÐÕÃûÒ»ÑùµÄÊý¾ÝÎÒÖ»ÒªÒ»Ìõ¾ÍÐÐÁË£¡

--Óû§ÐÕÃû
------------------
person.indiname

---

ÒÔËü·Ö×é

---

ÄãÄÇô*£¬¿´À´Ö»°Ñ¶àÌõ¼Ç¼µÄ±íÏÈ·Ö×飬ȻºóÔÙºÍÆäËü±í¹ØÁª

---

ÒýÓÃ

ÄãÄÇô*£¬¿´À´Ö»°Ñ¶àÌõ¼Ç¼µÄ±íÏÈ·Ö×飬ȻºóÔÙºÍÆäËü±í¹ØÁª

ÄÜ´ó¸Å¸øµã´úÂëÂð?лл£¡

---

"SELECT distinct top 8 dbo.jobs.CurrentName AS currentName, dbo.person.userid as xuserid," +

---

person±í
id indiname
1  xx
2  aa
3  bb
4  oo

companyyp±í
id companyPersonid
1  1
2  1
3  2
4  4
5  4

--²éѯ³öÀ´µÄÊý¾ÝΪ
id indiname
1  xx
4  oo

--񻂗