mysql查询与联接 [英] mysql query with join

问题描述

这是我的数据库:

我将检索richiestepreventivo中idImpresa == xx的所有记录以及privati中privati.id == richiestepreventivo.idPrivato的所有数据. 您能解释一下我必须如何使用join设置查询吗?

谢谢.

解决方案

SELECT *
FROM privati AS p
INNER JOIN richiestepreventivo AS r
      ON p.id = r.idPrivato
WHERE r.idImpresa = xx

您要的是简单的内部联接

this is my database:

I would retrieve all records in richiestepreventivo where idImpresa==xx and all the data in privati where privati.id==richiestepreventivo.idPrivato. Can you explain me how I have to set the query with join?

Thanks.

解决方案

SELECT *
FROM privati AS p
INNER JOIN richiestepreventivo AS r
      ON p.id = r.idPrivato
WHERE r.idImpresa = xx

Are you asking for a simple inner join

这篇关于mysql查询与联接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！