db2 right outer join

SQL right join keyword The right join keyword returns all rows from the right table (table_name2), even if no matching row exists in the left table (table_name1. Right join keyword syn

Label:SQL Right JOIN keywordThe right JOIN keyword returns all rows from the table (table_name2), even if there are no matching rows in the left table (table_name1).Right JOIN keyword syntaxSELECT column_name (s) from table_name1

(SC) there is no corresponding tuple, but we want to from the student table for the main list of each student's basic situation and elective course, if no students did not choose the course, only output its basic situation , the optional course information is empty, this is to use the outer connection, for example: Select Student.*,sc.cno,sc.grade from Student.sc where Student.sno=sc.sno (*); where Sc.sno (*) in the * is the

just one, then the A new record is formed in the returned result. As above person A and person B correspond. B. A city corresponding to each record in the Table1 if there is also an n bar in the Table2, then an n new record will be formed in the returned result. As the person C above corresponds to the case. C. A city corresponding to each record in the Table1 if it does not exist in the table2, it will form an entry in the returned result A new record, and the

Tags: style data sp on c R EF Size sql1, in TableA and TableB query TableA all data and TableB in TableA dataSELECT * FROM TableA A left join TableB B on A.key=b.key2, in the TableA query to exclude TableB data, the remaining TableA in the dataSELECT * FROM TableA A left join TableB B in A.key=b.key where B.key is null3, query TableA and TableB all the dataSELECT * FROM TableA A full