Hi
I wish to do two Left Joins, but im unsucessfull.
When I remove line no. 12 and line no. 15, it works.
I want to check in line 12 whether the ID Exists, and in Line No. 15 if it is NULL
Please help
1 -> Select
2- > a.ID_NO,
3 -> a.FULLNAME,
4 -> a.TEL_OFF,
5 -> a.TEL_RES,
6 -> a.MOB,
7 -> d.mohallaname
8 -> From
9 -> tblparent AS a,
10 -> tblmohalla AS d,
11 -> Left Join tbl_mpoll_1426 AS c ON c.fld_sabilid = a.ID_NO
12 -> Left Join tblsabil AS b ON b.ID_NO = a.ID_NO
13 -> Where
14 -> c.fld_sabilid Is Null AND
15 -> b.ID_NO Is Null AND
16 -> a.ID_NO >= 1 AND
17 -> a.ID_NO <= 9999 AND
18 -> a.UPDATED = 1 AND
19 -> a.MOHALLA = d.mohallaid
