conition if ,boucle where .

[#1]

Hello,

I created a view, this was Last chargée.Mais Where I want to use the loop.

example: where column_name = 'TEST' and 'TEST1';

do I know my loop or placed after the selection.

[Gysbert_Wassenaar]

A wild guess since I don't understand what you're asking:

TableA:

Load *

From mysourcetable

Where match(column_name, 'TEST','TEST1');

If that's not what you're looking for please explain in more detail or simply post your question in French so Google Translate can try to make English of it. Or perhaps post here instead: Groupe des Utilisateurs Francophones

[#3]

Bonjour ,

J'ai créé une vue, on la chargeant avec l'instruction Load,mais je voudrai utilisé la clause Where,on faisant .

load  nfac as 'numéro facture',

        sec as  section,

        cori as origine ,

seclect* from  vue_fact

where cori='Vvente'  and 'Vachat';

Merci e m'aider .

[Gysbert_Wassenaar]

Try:

load NFAC as 'invoice number'

         Dry as section

         cori as originally

seclect * from vue_fact

Where cori = 'Vvente' or cori = 'Vachat';