I FOUND A BUG IN SQL,
I HAVE TWO MEMORY TABLES:

"MEMORY\TABLE1"
 COD INTEGER
 DESCRIPTION VARCHAR(35)

"MEMORY\TABLE2"
 COD INTEGER
 DESCRIPTION VARCHAR(35)


 TABLE1 HAVE 10 RECORDS AND TABLE2 HAVE 8 RECORDS

 THIS SQL :
 
    SELECT * FROM "MEMORY\TABLE1","MEMORY\TABLE2"  

 IT WOULD HAVE TO RETURN 18 RECODS, CORRECT?  BUT IT RETURNED 80 RECORDS, WHAT IS WRONG?  
 IT SEEMS THAT IT MULTIPLIED THE RECORDCOUNTS.
 IT RETURNED REPEATED REGISTERS!

>> ROGER COSTA DE OLIVEIRA
     GRAVATAÍ/RS  (BRAZIL)
 
    TRANSLATED OF (PORTUGUESE TO ENGLISH)

Roger,

>      SELECT * FROM "MEMORY\TABLE1","MEMORY\TABLE2"  
>
>   IT WOULD HAVE TO RETURN 18 RECODS, CORRECT?

Incorrect. It is a cartesian product query so it will match every record
in TABLE1 against every record in TABLE2 - i.e. 10*8 = 80 records. What
I assume you were trying to do is this:

     SELECT * FROM "MEMORY\TABLE1"
     UNION ALL
     SELECT * FROM "MEMORY\TABLE2"

Eryk