MySQL Forums
Forum List  »  Microsoft SQL Server

self join
Posted by: pusalab
Date: August 25, 2005 11:57PM

SELECT name, owner, species, sex FROM mid WHERE name=owner;

this query does not work because we need to create the copy of the same table to execute self joins.but the above statement is working fine. what might bethe reason?

Options: ReplyQuote

Written By
self join
August 25, 2005 11:57PM
August 28, 2005 07:05AM
September 15, 2005 08:13AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.