Home >Backend Development >PHP Tutorial >javascript - How to write this sql using the join method in thinkphp?

javascript - How to write this sql using the join method in thinkphp?

WBOY
WBOYOriginal
2016-07-06 13:53:521093browse

SELECT a.,count() as num FROM sys_article a join sys_comment b on a.article_id=b.article_id where a.article_id=20

回复内容:

SELECT a.,count() as num FROM sys_article a join sys_comment b on a.article_id=b.article_id where a.article_id=20

<code>$Article->field('sys.article.article_id, count(*) as count')->join('__ARTICLE__ ON __COMMENT__.article_id = __ARTICLE__.article_id')->where('sys.article.article_id = 20')->select();</code>
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn