Re: self join

[Roland Bouman]

What do you mean, "create a copy"?

As far as i can see, this query just returns all rows that happen to have the value in the name field equal to the value in the owner field. This would be a sef join:

SELECT *
FROM mid n
inner join mid o
WHERE n.name=o.owner
;

No explicit copying involved.