Can any one recomend changes to simplify this SQL select?
select lim_val.code, lim_txt.lim_num, lim_txt.lim_text, ;
lim_txt.lim_suffix ;
from lim_val, lim_txt ;
where lim_txt.lim_num = lim_val.lim_num ;
and lim_txt.lang_code = m.lang_activ ;
union ;
select lim_val.code, lim_def.lim_num, lim_def.lim_text, ;
lim_def.lim_suffix ;
from lim_val, lim_def ;
where lim_def.lim_num = lim_val.lim_num ;
and lim_def.lang_code = m.lang_activ ;
and lim_val.code + str(lim_val.lim_num) not in ;
(select lim_txt.code + str(lim_txt.lim_num) ;
from lim_val, lim_txt ;
where lim_txt.code = lim_val.code ;
and lim_txt.lim_num = lim_val.lim_num ;
and lim_txt.lang_code = m.lang_activ)
