Skip to main content

SQL JOINS

    Left Outer Join: select column from table1 a left join table2 b on  a = b

      Right Outer Join: select column from table1 a right join table2 b on  a = b

        Left Excluding Join: Select column from table1 a left join table2 b on  a = b where b is null

          Right Excluding Join: Select column from table1 a right join table2 b on  a = b where  a is null

            Inner Join: Select column from table1 a inner join table2 b on  a = b

              Outer Join or full outer Join or full join: select column from table1 a full outer join table2 b on  a = b

                Outer Excluding Join: select column from table1 a full outer join table2 b on  a = b where  a is null or b is null

                Comments

                Post a Comment

                Popular posts from this blog

                Software Versions You Must Have..!

                Google Chrome       Version 29 and Version 37 of Google Chrome works much better than any other version.I updated my Google Chrome but it was lagging,not responding, crashed,contents were loaded very slow and few more.So,finally I found Google Chrome 37 working better,bugs fixed and you can download this to fix the previous problems. 2. KM Player Really awesome player to watch HD Videos,movies.Compatible with all extensions of videos you want to watch whether it is mkv,3gp,flv,HD,4K etc.KM Player has very good 3D mode.You can watch multiple videos at a time.I found version 3.6 & 3.9 useful,but in between versions were very Ads providing, lagging every time when you open the Player. 3. iTunes & Quick Time Player  Hats off to the creator 'Apple Inc.'. iTunes- name is enough.I use default audio player as iTunes.You can feel the sound clarity when you are changing it to other mode like Pop,Rock,Acoustic,Bass etc. iT...
                Post a Comment
                Read more

                End of support for Windows 10, Windows 8.1 and Windows 7

                Here's more you can read about the support:  link How you can move to Windows 11 Frequently asked questions   What can I do with my old computer? Trade it  in or  recycle it  with local organizations. Will my Windows 10 PC stop working? No. Your PC will continue to work, but support will be discontinued. How is Windows 11 more secure? Windows 11 is the most secure Windows ever built, with comprehensive end-to-end security that covers antivirus, firewall, internet protections, and more.  Read more  about Windows security.
                Post a Comment
                Read more