下面是内联接两个表,如过是三个,若干个表怎么写???
SELECT p1.pub_id,p2.pub_id,p1.pr_info
FROM pub_info AS p1 INNER JOIN pub_info AS p2
ON DATALENGTH(p1.pr_info)=DATALENGTH(p2.pr_info)
SELECT p1.pub_id,p2.pub_id,p1.pr_info
FROM pub_info AS p1 INNER JOIN pub_info AS p2
ON DATALENGTH(p1.pr_info)=DATALENGTH(p2.pr_info)
from tb1
inner join tb2 on tb2.field1=tb1.field1
inner join tb3 on tb3.field1=tb2.field1
......
FROM pub_info AS p1 INNER JOIN pub_info AS p2
ON DATALENGTH(p1.pr_info)=DATALENGTH(p2.pr_info) inneer join p3 on datalegnth(p1.pr_info)=datalength(p3.pr_info) ......