Hi All,
I have the string below and I want to use the string in the first, second, and third positions in three join conditions in 3 different subqueries.
The string will always have 3 values separated by a dash "-".
A-B-C
SELECT * FROM t1 WHERE c1 = 'A';
SELECT * FROM t1 WHERE c1 = 'B';
SELECT * FROM t1 WHERE c1 = 'C';