[libreoffice-users] Base and SQL problems

Hi,

I'm new with Libre Office base and there is my actual problem...

(excuse my english, I speak french)

I have a base with a lot of tables. 
Tables for Prefix, first name (prenoms) and Family names (Noms)

In another table, I have PERSONS table: build from the 3 previous table.

So on the Form, I see names, first name etc. but in the table only numbers are presents.

I don't know if it is clear....

The problem is  in Propriety list zone on the data tab, for list content,  on the form, to 
concatenate PREFIX FIRSTNAME FAMILY NAME, I have this:

SELECT "PREFIX"."Prefix" || ' ' || "PRENOMS"."Prenom" || ' ' || "NOMS"."Nom", "PERS"."Idpp" FROM 
"PERS"
 LEFT JOIN "PREFIX" ON "PREFIX"."Cprefix" = "PERS"."PREFIXC"
 LEFT JOIN "PRENOMS" ON "PRENOMS"."Cpr" = "PERS"."PRENOMC"
 LEFT JOIN "NOMS" ON "NOMS"."Idnom" = "PERS"."NOMC"
ORDER BY "NOMS"."Nom"

It's work but each time I quit this base and reopen it, Base keep only the first line of this sql 
things...

Any help would be appreciate.

Thx

Denis
-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted