我有两个MySQL查询
QUERY:
SELECT sodnik_1 FROM prihodnji_krog WHERE file_id='8778' AND sodnik_1 != ''
UNION
SELECT sodnik_2 FROM prihodnji_krog WHERE file_id='8778' AND sodnik_2 != ''
UNION
SELECT sodnik_3 FROM prihodnji_krog WHERE file_id='8778' AND sodnik_3 != ''
UNION
SELECT sodnik_4 FROM prihodnji_krog WHERE file_id='8778' AND sodnik_4 != ''
QUERY:
SELECT value FROM notification_sodniki WHERE user_id='16'
OUTPUT LOOKS LIKE THIS:
Name 1
Name 2
Name 3
Name 4
IN BOTH TABLES
他们给我1列。我想执行交叉连接,并仅返回两个选择查询中均存在的值。这可能吗?
COLLATE
https://dev59.com/PnA75IYBdhLWcg3w7tx6 或者更改编码使其对两者都相同。 - Marc