SQL - Part 58 - Tables and Aliases

[@manjubai1636]

Thank you sir

[@QAFox]

Welcome :)

[@amolpatil8173]

Can we insert multiple rows to the table using single insert into Statement

[@shivamkhandelwal9327]

Isn't it the use of intersection ?

[@sMoke_101]

why we not using as keyword here

[@QAFox]

Its optional.

[@sMoke_101]

@@QAFox in table or in coulmns also

[@yacoubouabdallah5568]

good

[@QAFox]

Thank you :)

[@lipsheetaswain109]

Hi Sir, If we can call 2 tables like this then why we are using Union operator?

[@vaibhavvajpai2353]

Both are different.. in set operator same number of columns should be called from both tables and records as arranged in rows.. whereas here we are calling different number of columns from different tables and result is arranged in horizontal columns