Query1. I have the SQL table and Excel file. I want a left join between them based on three lookups. But when i am sourcing it in SQL Query it shows an error. My main issue is that I want a join in SQL Table not by making a composite key. I want it in below way as I have three lookups
LIB CONNECT TO 'TIGUNVMBGWL0011';
DIN AS DAN,
MAN AS MN,
(ooxml, embedded labels, table is Sheet1);
FROM tempdb.dbo."Case" C
LEFT JOIN AccountTemp A ON A.CLN = C.CIN AND A.DIN = C.DAN AND A.MAN = C.MN ;
Query 2: Is it possible two make a join of two resident table based on three lookups with where clause.
As for E.g.
I have two resident table Account & Case
RESIDENT ACCOUNT A
LEFT JOIN CASE B ON A.A = B.B AND A.C = B.D AND A.E = B.F