tag:blogger.com,1999:blog-7795277007143786051.post4152107363228981315..comments2023-03-30T07:36:31.506-07:00Comments on Java @ Desk: Difference between Equi Join, Natural Join and Cross Join in sqlAnonymoushttp://www.blogger.com/profile/07576885198163157451noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7795277007143786051.post-10174076957955405442016-12-01T19:32:00.014-08:002016-12-01T19:32:00.014-08:00we can not use where clause in natural join .
we can not use where clause in natural join .<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7795277007143786051.post-57159767902876343632015-11-24T23:37:45.651-08:002015-11-24T23:37:45.651-08:00in result of natural join and equi join one more r...in result of natural join and equi join one more row should be added as<br />1 john 3 newyorkAnonymoushttps://www.blogger.com/profile/04903891356385844523noreply@blogger.comtag:blogger.com,1999:blog-7795277007143786051.post-52019033734054802622015-11-24T23:36:09.692-08:002015-11-24T23:36:09.692-08:00in the result of natural join and equi join one mo...in the result of natural join and equi join one more column should be added <br />where emp_id=1.<br />1 john 3 newyorkAnonymoushttps://www.blogger.com/profile/04903891356385844523noreply@blogger.comtag:blogger.com,1999:blog-7795277007143786051.post-35880298070219606552014-12-12T06:57:16.641-08:002014-12-12T06:57:16.641-08:00Nice observation. Corrected the results. Please ve...Nice observation. Corrected the results. Please verifyjavacodeimplehttps://www.blogger.com/profile/08194861504106909818noreply@blogger.comtag:blogger.com,1999:blog-7795277007143786051.post-55829795094217466142014-12-10T15:02:38.982-08:002014-12-10T15:02:38.982-08:00is the second row in the cross join example correc...is the second row in the cross join example correct? I was expecting 4x jhons, 4x david, ect ect-Cba-https://www.blogger.com/profile/15393597710439827242noreply@blogger.com