SELECT
PC_SL_ACNO,
SLNAME,
SL_TOTAL_AMOUNT
FROM GLAS_PDC_CHEQUES
WHERE PC_COMP_CODE=@COMP_CODE AND PC_BANK_FROM = @PB_BANK_CODE AND
PC_DUE_DATE BETWEEN @DATE_FROM AND @DATE_TO AND ISNULL(PC_DISCD,'X') IN('X','R') GROUP BY
PC_COMP_CODE, PC_SL_LDGR_CODE, PC_SL_ACNO
ORDER BY PC_SL_ACNO
SLNAME:
SELECT COAD_PTY_FULL_NAME INTO :BLOCK03.SLNAME
FROM GLAS_PTY_ADDRESS,GLAS_SBLGR_MASTERS
WHERE SLMA_COMP_CODE = @COMP_CODE
AND SLMA_ADDR_ID = COAD_ADDR_ID
AND SLMA_ADDR_TYPE = COAD_ADDR_TYPE
AND SLMA_ACNO = @PC_SL_ACNO
AND SLMA_COMP_CODE = COAD_COMP_CODE;
TOTAL AMOUNT:
SELECT SUM(PC_AMOUNT) INTO :SL_TOTAL_AMOUNT
FROM GLAS_PDC_CHEQUES
WHERE PC_DUE_DATE BETWEEN @DATE_FROM AND @DATE_TO
AND PC_BANK_FROM = @PB_BANK_CODE
AND PC_SL_ACNO = @PC_SL_ACNO
AND NVL(PC_DISCD,'X') = 'R'
AND PC_COMP_CODE =@COMP_CODE;
how can i join this based on these condition ...pls help
|
| Author: Shameer 08 Nov 2009 | Member Level: Silver | Rating:  Points: 2 |
Could u pls send the table structure clearly instead of query and inform briefly what you have to join
|
| Author: mithun 16 Nov 2009 | Member Level: Silver | Rating: Points: 2 |
plz b clear n ur question......
|