ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

Briefly describe an outer join ?

user-image
تم إضافة السؤال من قبل Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company
تاريخ النشر: 2015/01/07
Vinod Jetley
من قبل Vinod Jetley , Assistant General Manager , State Bank of India

A left outer join retains all of the rows of the “left” table, regardless of whether there is a row that matches on the “right” table. What are the “left” and “right” tables? That’s easy – the “left” table is simply the table that comes first in the join statement – in this case it is the Employee table, it’s called the “left” table because it appears to the left of the keyword “join”. So, the “right” table in this case would be Location.

Samiur Rahman
من قبل Samiur Rahman , System Engineer/Project control coordinator , Chiyoda Corporation

Outer Join: Display all the record of one table and the only matching record for second table.

المزيد من الأسئلة المماثلة