[FLINK-18781] Example in table/sql/queries.md Exists section is not correct

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 1.11.1, 1.12.0
• Component/s: Documentation, Table SQL / API
• Labels: stale-major
• Assignee: Unassigned
• Reporter: Benchao Li
• Created: 31/Jul/20 09:04
• Updated: 29/Apr/21 15:51
• Resolved: 29/Apr/21 15:51

Description

the sql should be:

SELECT user, amount
FROM Orders 
WHERE EXISTS (
    SELECT product FROM NewProducts WHERE Orders.product = NewProducts.product
)