I've written a Left join between two tables. My table structure is
SELECT D.DLNOPK, D.STARTDT
FROM DEALDETAILS D
LEFT JOIN
DEALCUSTOMERDETAILS P
ON P.DLNO = D.DLNOPK
WHERE P.CUSTOMERID = 'ABCD';
Here the total query you ask ^^
SELECT D.DLNOPK, D.STARTDT
FROM DEALDETAILS D
LEFT JOIN DEALCUSTOMERDETAILS P
ON D.DLNOPK = P.DLNO
WHERE P.CUSTOMERID = 'ABCD';