suitable connection method

Question

Hello.

I need to consolidate the company's employees. I now have three tables, each with a unique EmpID, through which I want to concatenate the three tables.

tableA contains basic information about individuals, names, etc.

tableB contains contact information, etc., and some are empty.

tableC contains simple family relationships, some are empty.

Please recommend a suitable connection method.

Thanks in advance.

Answer 1

Hi @ll1-2690

According to your description, you can use the left outer join, like this.

select * from tableA as A left outer join tableB as B on A.EmpID = B.EmpID
	                      left outer join tableC as C on A.EmpID = C.EmpID;

Best regards,

Percy Tang

---

If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.