I am having an issue with a join, can you help me please?
SELECT tbl1.C1 FROM T1 tbl1
INNER JOIN (SELECT C1, MIN(C2) FROM T2 WHERE C3=1 GROUP BY C1) tbl2 ON tbl1.C1=tbl2.C2
I get an error when trying to reference the inner selection as tbl2.
How can I do it please?