( NOTE : ABOVE ADVANTAGE IS WE CAN DISPLAY ONLY WHAT WE NEED THAT THINGS ONLY WE CAN ADD TO QUERY BUT ALL THE INNER QUERIES ARE EXECUTED BUT WE CAN RESTRICT WHAT DISPLAY IN OUTER SUBQUERY) ...
1. IT COMBINES BOTH THE TABLES. 2. NOTE -> SELECT FIELDS SHOULD BE SAME NO OF COLUMNS THEN ONLY IT RUNS OTHERWISE IT THROWS ERROR. 3. ONLY DIFF BETWEEN UNION AND UNION ALL IS UNION ELIMINATE THE ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results