tag:blogger.com,1999:blog-8862431614706570562.post4878552910235853663..comments2015-01-30T00:16:20.702-08:00Comments on SQL and Database: Self-join in sql with exampleUnknownnoreply@blogger.comBlogger6125tag:blogger.com,1999:blog-8862431614706570562.post-53533446998985047392015-01-30T00:16:20.702-08:002015-01-30T00:16:20.702-08:00not better explanationnot better explanationAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8862431614706570562.post-32473657446632854172014-06-04T03:41:18.210-07:002014-06-04T03:41:18.210-07:00good1.,good1.,Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8862431614706570562.post-9124195576037777662014-05-24T23:06:22.306-07:002014-05-24T23:06:22.306-07:00I think you have expalined in reverse way...
e1 mu...I think you have expalined in reverse way...<br />e1 must me employee and e2 must be manager her... but you have explained in reverse......Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8862431614706570562.post-48826833586873989592014-05-17T08:56:49.739-07:002014-05-17T08:56:49.739-07:00Actually, i think the last query could have been e...Actually, i think the last query could have been explained, in bit easy manner like, in self join the table e2's one row is actually fixed while doing a scan for inner join. When the value of e1.employee_location from the first table is being compared with the e2.employee_location, here actually e2.employee_location gets fixed to 'New York', because we are doing an AND operation on table e2 and saying that,we need employee_location value, whose employee_name must always be 'Joe'.<br /><br />Hope it makes this query bit easy to understand......Satyahttps://www.blogger.com/profile/13571543680478545442noreply@blogger.comtag:blogger.com,1999:blog-8862431614706570562.post-53156393549851478582014-03-27T04:05:46.448-07:002014-03-27T04:05:46.448-07:00SRY......u might have explained bit easy....SRY......u might have explained bit easy....Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8862431614706570562.post-39783818083392275802013-04-05T03:58:06.224-07:002013-04-05T03:58:06.224-07:00goodgoodAnonymousnoreply@blogger.com