SELECT e.empid, e.FNAME, e.MNAME, e.LNAME, o.Department, o.Designation, s.wdays,
s.BASICSAL,
s.gross_earn, s.gross_ded, s.net_salary
FROM EDETAILS AS e INNER JOIN
EProfile AS o ON e.empid = o.empid INNER JOIN
ESAL AS s ON e.empid = s.empid
i have this in atble configuration wizard
i dont get values of
e.FNAME, e.MNAME, e.LNAME, o.Department, o.Designation
i get the values in sql analyser aslo