>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)
>
>

Eeek. Could you explain, in plain english, the business nature of the select? That would help me.