您好,
我有两个表
1)公司
Company_id Int
Name Varchar
Address Varchar
2)会议
{C}
我的SQL是像下面
问题是,当我运行这个查询的结果将不低于符合查询的结果数据。SELECT *
FROM Company C
WHERE c.name LIKE 'a%'
AND EXISTS
(
SELECT 1
FROM Meeting M
WHERE c.Company_id = M.Company_id
AND M.Country_id = 2
AND M.State_id = 10
)
AND EXISTS
(
SELECT 1
FROM Meeting M
WHERE C.Company_id = M.Company_id
AND M.start_date>= '2011-01-01'
AND m.end_date<= '2011-12-31'
)
{体C3}
我只是想知道我想在此查询的东西吗?