>>For ease of reading and maintenance I'd recommend using local aliases e.g.
>>
>>SELECT A.Numero, ...
>>FROM Master A ;
>>...
>>
>
>Don't use one letter as table aliases especially first few letters. AFAIK it may produce some unpredictable results...
With regular xBase expressions yes, that's true. You should avoid A through J inclusive as they correspond to the original 10 work areas available in dBASE/FoxBase.
Local aliases in the SQL engine are a different/separate thing entirely. The following code is a "worst-case" scenario that illustrates this:
CREATE TABLE TestA ;
( iValue I )
INSERT INTO TestA ;
( iValue ) ;
VALUES ;
( 1 )
INSERT INTO TestA ;
( iValue ) ;
VALUES ;
( 2 )
CREATE TABLE TestB ;
( iValue I )
INSERT INTO TestB ;
( iValue ) ;
VALUES ;
( 3 )
INSERT INTO TestB ;
( iValue ) ;
VALUES ;
( 4 )
CLOSE DATABASES ALL
USE TestA ALIAS A IN 0
SELECT ;
A.* ;
FROM TestB A ;
INTO CURSOR TestOut
SELECT TestOut
BROWSE
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up