mysql - 如何在学说上使用内连接

Question

用户表

id name sex
1  john female
2  bob  male
3  tom  female

日程表

id title
2  work     // bob goes to work
2  shopping 
3  shopping // tom goes to shopping
1  work

Schedule.id是User的外键。

我想从用户表中选择行有计划去购物的人

2  bob male
3  tom female

我该怎么做？

这是我现在的绳子，它可以从明细表中选择行。但我想从用户表中选择行。我认为内连接很重要,,,,,

$query = $em->createQuery(
SELECT p 
FROM UserBundle:Sche p 
WHERE p.title = 'shopping') ;

$result = $query->getResult(); 

Answer 1

试试这个:

$query = $em->createQuery(
    SELECT a.id, a.name, a.sex, b.title
    FROM User a
    INNER JOIN 
    Schedule b ON a.id = b.id
    WHERE b.title = 'shopping'
);
$result = $query->getResult();