-
1.kantenbreken
2.lassen
3.snijden
4.vormen
5.zetten
6.laskanten
this is operation_Id (checkbox)
and
5.snijden/zetten
6.zetten
7.snijden/vormen
8.snijden
9.snijden/vormen/lassen
10.snijden/laskanten
11.snijden/laskanten/zetten
and this is workchain_id (workchain_id)
when I select multiple choice like(snijden/vormen/lassen) in checkbox
In workchain_id it should select default
example like: snijden/vormen/lassen -
select w.workchain_id from workchain w join workchain_operation wo on
wo.workchain_id=w.workchain_id join operation p on p.operation_id=wo.operation_id
where p.operation_id= (select operation_id from operation where operation_id=3) this query is working in ssms and In gui its not working -
Guys you know any solution for this
Best answer by Erwin Ekkel
View original