如何在table1中生成不包含id和用户名的gat数据

Question

我有一个表，如表1和Table2

Table1包含

id  |  area  | Merchant
-----------------------------
1   | Area1  | Merchant1
-----------------------------
2   | Area1  | Merchant2
-----------------------------
3   | Area2  | Merchant3
-----------------------------
4   | Area3  | Merchant4
-----------------------------

Table2包含

id  |merchant_id| user_id
-----------------------------
1   | 1         | user1
-----------------------------
2   | 2         | user2
-----------------------------
3   | 1         | user2
-----------------------------
4   | 1         | user3
-----------------------------

我的问题是，我想显示来自Table1的商人名称，但是当用户渴望的时候，它不应该包含在Table2中。

这个查询不起作用，请帮助我

SELECT t1.id,t1.merchant
FROM table1 AS t1 ,table2 AS t2
WHERE (t1.id NOT LIKE t2.merchant_id AND t2.user_id NOT LIKE 'user1') AND
      t1.area like 'area1' 

Answer 1

SELECT      CA.ID

           ,CA.MERCHANT

FROM       CITY_AREA_PLACE AS CA

WHERE CA.ID NOT IN ( SELECT FL.MERCHANT_ID

                     FROM USER_FAV_LIST AS FL

                     WHERE  FL.USER_ID = 'STARINGH@GMAIL.COM'

                           AND CA.AREA = 'GACHIBOWLI' );