Re: DELETE with OuterJoin

Hi Igo Look: table and view are diferent things. If you create a view using join (select col1, col2, col3, .... coln from tab1, tab2 where tab1.colx=tab2.colx ....) you'll never update, insert or delete rows in this view. You have to do this events in separated tables... and use the view ONLY TO SELECT ... no other operations are allowed. Best regards. Ferronato Igo Besser escreveu: > Hi to all, > > as result of an app-error there are rows in the master-table are deleted but > not the associated rows in the detail-table. In a view using an outer join I > can see the wrong rows - but I can not delete (view). > So I search for a construct of a delete-statment that enclose instead of the > table-name a"select"-statment like it is used in the "create > view"-statment. > > I can not find any documentation who to write this - with "try and error" I > have not become a result ... > > Igo