how can implemented subquery in flink

[hager sallah]

  how can implemented subquery in flinkexample
SELECT C_CUSTKEY,C_NAME
FROM Customers where C_MKTSEGMENT=(select C_CUSTKEY,C_MKTSEGMENT from Customers 
where C_ADDRESS="MG9kdTD2WBHm")