SQL View with distinct

Greenhorn

Posts: 1

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Der Friends,

Please clarify my below question.

DML(Inset,update and delete) operations are not possible when view contains a "Distinct"

Please let me know the reason.

Thanks
Siva

Jan Cumps

Bartender

Posts: 2662

I like...

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Because a view with DISTINCT does not return results that map back to a single record.

OCUP UML fundamental and ITIL foundation