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

                how to solve: nginx Permission denied problem

                  *71 connect() to unix:/run/php/php7.4-fpm.sock failed (13: Permission denied) while connecting to upstream, client: <ip here>, server:  <ip here>, request: "GET /iomad/ HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.4-fpm.sock:", host: "<ip here>" just give permission  to  php7.4-fpm.sock i solved it by giving sudo chmod -R 0777     php7.4-fpm.sock Also i tried to open the file but there was again permission denied issue  i visited my website and it was working
                Post a Comment
                Read more

                Indian HAL Tejas | Touch The Sky With Glory | ShotOnNikonD3500

                Indian HAL Tejas | Touch The Sky With Glory | ShotOnNikonD3500
                Post a Comment
                Read more

                installing Laravel v8.0.1 in Windows 10 Pro x64bit

                 Using WAMP for  php - 7.4.10 maraiadb - 10 apache - 2.4 php -i | grep -i ssl  to check registration stream socket transports grep -R "search your word" use this cmd to search in linux directory composer diagnose to see the status of composer check with this link also:  https://github.com/composer/composer/issues/4388 Failed to download tijsverkoyen/css-to-inline-styles from dist: The "https://api.github.com/repos/tijsverkoyen/CssToInlineStyles/zipball/b43b05cf43c1b6d849478965062b6ef73e223bb5" file could not be downloaded: php_network_getaddresses: getaddrinfo failed: No such host is known.     failed to open stream: php_network_getaddresses: getaddrinfo  failed: No such host is known.  Now trying to download from source https://github.com/tijsverkoyen/CssToInlineStyles   install the  composer require tijsverkoyen/css-to-inline-styles ======================================================================= These are final steps: ...
                Post a Comment
                Read more