Select on View

[Beatrix Willius]

Hello,

is the following a problem or a feature:

- The table Message contains a field called CheckSum.
- A view is created with

create or replace view CheckDuplicates as (select CheckSum, count 
(CheckSum) as CountOfDup from Message group by CheckSum)

- A view is created on this view

create or replace view DeleteDups1 as (select RecID, * from Message  
inner join CheckDuplicates on CheckDuplicates.CheckSum =  
Message.CheckSum where CheckDuplicates.CountOfDup > 1)

- A select done on this view like the very simple

select * from DeleteDups

gives the error message

15:18:48: Error: Field name "CheckSum" is not unique.
15:18:48: Error: Kernel error: 0x80501
15:18:48: Error: Field name "CheckSum" is not unique.




Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: archive, clean and search email
http://www.beatrixwillius.de
Fractals, 3d landscapes etc.