SQL SELECT JOIN

JOIN command in SQL allow you to retrieve data from more than one table and mix and match them. The structure  is the following: SELECT <alias1>.<column1>, <alilas2>.<column2> FROM <tableName1> AS <alias1> JOIN <table2> AS <alias2> ON <alias1>.<matchingColumn1> = <alias2>.<matchingColumn2>; After the "ON" we put the matching condition that tell the SQL how to match rows … Continue reading SQL SELECT JOIN

Linux join command

join command combine the line from 2 files. and make new lines, that every line contain in the beging the line from the first file, follow by the corresponding line from the second one. The structure is the following: join <fileName1> <fileName2> For example we file1 contain  Washington London Paris and file2 contain United State United … Continue reading Linux join command