SQL SERVER2012 右连接

admin

SELECT
    s.[ID],
    s.[store],
    s.[store_name],
    s.[conn],
    s.[equipmentNo],
    s.[timestamp],
    s.[note],
    s.[region],
    c.[shopNo]
FROM
    [lj_tc].[dbo].[STORE_TERM_STORE] s
LEFT JOIN
   [lj_tc].[dbo].[STORE_TERM_CONN] c ON s.[conn] = c.[ID]
WHERE
    s.[store] LIKE '%测试%'
    OR s.[store_name] LIKE '%测试%';