| Record Duplication on Reports (report on 5 pages) [message #88987] |
Thu, 17 July 2003 01:27 |
Tariq Zia
Messages: 5
Registered: May 2002
|
Junior Member |
|
|
Hye!
I have three Tables.
In first Master table I have 1 record.
In sencond detail table in 3 record
and in third detail table in 5 record.
when i run my report i have received 5 pages with same record (no chaning) but i need only one page.
I have composite Primary key CONTRACT_ID,ORG_ID,UNIT_ID)
when i join my Querry with three table i have received 15 records but (it should be 5 reocrd)
i am making joing with (1st table to second table, then, 1st table to third table, then , 2nd table to 3rd table)
i am sending my Querry.
plz reply immediately.
SELECT SL_CONT_MST.CONTRACT_ID
FROM SL_CONT_MST,SL_CONT_DTL,SL_CONT_DESC
WHERE SL_CONT_MST.CONTRACT_ID = SL_CONT_DTL.CONTRACT_ID
AND SL_CONT_MST.ORG_ID = SL_CONT_DTL.ORG_ID
AND SL_CONT_MST.UNIT_ID = SL_CONT_DTL.UNIT_ID
AND SL_CONT_MST.CONTRACT_TYPE ='L'
AND SL_CONT_MST.CONTRACT_ID =SL_CONT_DESC.CONTRACT_ID
AND SL_CONT_MST.ORG_ID =SL_CONT_DESC.ORG_ID
AND SL_CONT_MST.UNIT_ID =SL_CONT_DESC.UNIT_ID
AND SL_CONT_DTL.CONTRACT_ID =SL_CONT_DESC.CONTRACT_ID
AND SL_CONT_DTL.ORG_ID =SL_CONT_DESC.ORG_ID
AND SL_CONT_DTL.UNIT_ID =SL_CONT_DESC.UNIT_ID
Regards.
Tariq Z. Lakho (Karachi-Pakistan)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
