Hi all ,
I m facing with one issue, i.e
See below data.
Table1:
Load Tic_No,
CallDate,
Branch,
Division,
Region
From ,,,,,,,,
Table 2:
Load Tic_No,
MobleNo,
Base_Id
From,,,,,,
Table 3:
Load Base_Id,
Address
from,,,,,,,,,
What i want is, i want MobleNo and Address in table 1 with same Tic_No Count for All Div , region and branch.
I did Like this:
Table1:
Load Tic_No,
CallDate,
Branch,
Division,
Region
From ,,,,,,,,
Left Join
Load Tic_No,
MobleNo,
Base_Id
From,,,,,,
Table 3:
Load Base_Id,
Address
from,,,,,,,,,
But its Not working.Please Give me some valid solutions.
