Hi Markus,

Thanks for your reply. The information you asked are as follows

Front End - Delphi 5.0

Firebird Version 2.0

IBO : IBO_4_6_B

The SQL :

SELECT YY.*,EM.EMPNAME,EM.DOB,EM.SEX,EM.MARITAL,EM.DOJ,
EM.AUTOCUT,EM.EMPBNKCODE,EM.EMPACNO,EM.EYRBNKCODE,EM.EYRACNO,EM.STATUS,
EM.PFNO,EM.PANNO,EM.ESINO,EM.PFJOINDATE,EM.NOTICEPERIOD,EM.PHOTOPATH,
EM.EMAILID,EM.EMPFATHERNAME,EM.EMPPRADD1,EM.EMPPRADD2,EM.EMPPRADD3,EM.EMPPRPINCODE,
EM.EMPPRPHONENO,EM.EMPPEADD1,EM.EMPPEADD2,EM.EMPPEADD3,EM.EMPPEPINCODE,EM.EMPPEPHONENO,
EM.EMPDISPENSARY,EM.EFFDATE,EM.CCCODE,EM.FROMDATE,EM.APPLIEDDATE,
EM.RESIGNNOTSETTLE,EM.LASTPRESDATE,EM.CALCSTATDED,EM.PFGROUPCODE,EM.LGCODE,
EM.RETIREMENTDATE, EM.PENSIONNO,EM.ESIAPP, DG.DSGNAME, DP.DPTNAME, B.*
,(TRIM(B.FLATNO)|| ' '||TRIM(B.BUILDINGNAME) || ' ' ||TRIM(B.ROADADDRESS)|| ' ' || TRIM(B.AREA) || ' ' || TRIM(B.CITY) || ' '
|| TRIM(B.PIN)) ONELINEADDR FROM AD1_TEMPREPYPAYROLLMASTER YY,
EMPLOYEEMASTER EM, DESIGNATIONS DG, DEPARTMENTS DP, AD1_REPFORMSHEADER
B WHERE ((EM.EMPCODE = YY.EMPCODE) AND (YY.DSGCODE = DG.DSGCODE)
AND (DP.DPTCODE = YY.DPTCODE) AND (YY.PGCODE='STAFF') AND (ESI <> 0))
ORDER BY YY.YEARMONTHS,EM.EMPCODE


Thanks in advance

Niegil Thomas



Send free SMS to your Friends on Mobile from your Yahoo! Messenger. Download Now! http://messenger.yahoo.com/download.php

[Non-text portions of this message have been removed]