The following code executes the SQL query string:execute(@query) Press the "F5" key to execute the code. The query runs, and you see a list of customers with the specified first and last name ...

The result set will have three columns, column1, Two and Three — where Two contains values from table1.column2 and table2.column4 and Three contains values from table1.column3 and table2.column5.

The ease and ubiquity of SQL have even led the creators of many “NoSQL” or non-relational data stores, such as Hadoop, to adopt subsets of SQL or come up with their own SQL-like query languages.