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?
- WBOYOriginal
- 2016-07-06 13:53:521082browse
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
Previous article：How does PHP determine whether a PHP page was submitted from Next article：How does PHP determine whether a PHP page was submitted from