Re: [SQL] Language dependent fields

Hi, thanks, that works ok. But has anybody some suggestions how this behaves performance wise, if I have like 10 language dependent fields and translation t1 till translation t10. Volker Renato De Giovanni wrote: > > Maybe something like this: > > CREATE VIEW locale_customer2 AS > SELECT cust

[SQL] Language dependent fields

Hi, I want the content of a field to be language dependent. Therfore we have a Translation table which looks like this: tln_id tln_lng_id tln_text - 1 de hallo 1 en hello 2 de Herr 2 en