bad result SQL

[olivier]

hi,

The result of my request SQL is different according to the place of 
columns in the request.
It is normal?

-> GOOD RESULT:

SELECT Vrate,Pvalue FROM

Fam_Price_TypSal_TypPrice,
Fam_Vat_TypVat_TypSal,
price,typsalle,family,vat,typprice,typvat

WHERE snom=salle

-> BAD RESULT:

SELECT Vrate,Pvalue FROM

Fam_Price_TypSal_TypPrice,
Fam_Vat_TypVat_typSal,
price,family,typsalle,vat,typprice,typvat

WHERE snom=salle

The only difference is that " typSalle " and "family" were inverted.
In the first case, I indeed have a good result with all the lines. In 
the second case, I have only the first line.

----------------
DATABASE
----------------

Bo Family

- colonne FName (vstring)

Bo Price

- colonne Pval (float)

Bo VAT

- Vname (vstring)
- Vrate (float)

Bo TypPrice

- Rname (vstring)

Bo TypSalle

- Sname (vstring)

Bo TypVAT

- Wname (vstring)

Bo Fam_Price_TypSal_TypPrice

- FamPtr (Family Ptr)
- PricePtr
- TypPricePtr
- TypSalPtr

Bo Fam_Vat_TypVat_TypSal

- FamPtr
- VatPtr
- TypSalPtr
- TypVatPtr

I can send you the file vdb (84 ko) and data (2.9Mo)

Thank you very much.

olivier