Merging two sheets

This is what I have

Sheet 1 has two columns
Col1 ; Col2
Job; program ( combination of Job + program is unique )
ABC4DX; ABC123
ABC4DX; ABC475
AXC123X; AXC123
ABC135x; ABC124

Sheet 2 (This is a super set, has many rows , some are matching to the sheet 1 and some not , the job + program will have duplicates)

Col1; Col2; Col3; Col4; Col5; Col6
Job; program; DBB; insert; update; lock
ABC4DX; ABC123; PVM; I; ; L
ABC4DX; ABC123; PTM; I; ; L
AXC123X; AXC123; PVX; ; U ; L
AXC123X; AXC234; PVM; I; ;

Matching Key between the two sheets = Job + program

Please note:
The First row of the Sheet1 has two matching rows in Sheet 2 (First two rows of sheet2)
The second and fourth row of the sheet1 has no matching in the sheet2
The third row of the sheet1 has one matching row in the sheet2(3rd row of the sheet2)
The 4th row of the sheet2 also has no matching row in the sheet1


What I need:

I need to update the sheet1 bringing Cl3,col4,col5,col6 from sheet2 for the matching rows (matching key is job + program)

Should look like this

Job;; program;; DBB;; insert;; update;; lock;;
ABC4DX;; ABC123;; PVM;; I;; ;; L ;; (Brought two rows from Sheet2)
ABC4DX;; ABC123;; PTM;; I;; ;; L ;;
ABC4DX;; ABC475;; NA;; ;; ;; ;; (No row found)
AXC123X;; AXC123;; PVX;; ;; U;; L;; (One row found in sheet2)
ABC135X;; ABC124;; NA;; ;; ;; ;; (No row found)

Can someone help in getting this done ?

Can anyone please look into this problem ?

Any clues on this one, I am still waiting on this one.. Thanks