How to do a join with inner query result in flexible ?

[Former Member]

select {a:unit},{a:product} from {tableA as a left join ({{select * from tableA as a join tableB as b on {a:product}={b:product} join tableB as b1 on {a:unit}={b1:unit}}}) as filter on {a:product}={filter:product} and {a:unit}={filter:unit}}

Bellow error I am getting, I think it's some syntax error :- missing '{' for '}' at 244 in ') as filter on {a:product}={filter:product} and {a:unit}={filter:unit}} '

[Former Member · Accepted solution]

SELECT Table1.Numbers, Table1.Name FROM Table1 WHERE NOT EXISTS( SELECT 1 FROM Table2 WHERE Table1.Numbers=Table2.Numbers ) used this query , working properly

[former_member570877 · Accepted solution]

Hi Amit,

Can you please provide the flexible search query for the original query :

select {a:unit},{a:product} from {tableA as a left join ({{select * from tableA as a join tableB as b on {a:product}={b:product} join tableB as b1 on {a:unit}={b1:unit}}}) as filter on {a:product}={filter:product} and {a:unit}={filter:unit}}

Thanks in advance.

Thanks,
Vikram