mysql - Join Select Statement after on -
is possible join on part of string split up? tried something:
select param.par_name, parpat.pp_pattern, kom.kom_name inv.inv_parpat parpat inner join inv.inv_param param on parpat.pp_par_id = param.par_id inner join inv.inv_komponente kom on kom.kom_id = (select substr(parpat.pp_pattern, instr(parpat.pp_pattern, ':') + 1 ) inv.inv_parpat) parpat.pp_pattern '%ata%';
this statement says: single row subquery returns more 1 row
you need join parpat based on substring column. if join subquery,the subquery should return 1 value (like max() or min() function do). else can use in clause subquery. remember, there performance considerations while using in. case, try below query:
select param.par_name, parpat.pp_pattern, kom.kom_name inv.inv_parpat parpat inner join inv.inv_param param on parpat.pp_par_id = param.par_id inner join inv.inv_komponente kom on kom.kom_id = (substr(parpat.pp_pattern,instr(parpat.pp_pattern, ':')+1)) parpat.pp_pattern '%ata%';
Comments
Post a Comment