I have two variables and they actually contain the same thing. Now if I change query0 I want the value in query1 to be selected. Conversely, if I change query1, I want the value in query0 to be selected.
Thought I’d do that in SQL via
query0
Select org_l1.name as 'Line', org_l1.id_kunde as Workcenter From org_l1 WHERE org_l1.id_kunde = ~ /$query1$
/
query1:
Select org_l1.id_kunde as Workcenter, org_l1.name as Line From org_l1 WHERE org_l1.name = ~ /$query0$/
Unfortunately that doesn’t work. Anyone have an idea?