show master details .. [message #356890] |
Mon, 03 November 2008 00:50  |
adilsami
Messages: 46 Registered: October 2007
|
Member |
|
|
I want show the master record , even if the detail record doesn't exists ..how i can do that .
When i pass value to (:assetno) it should show me the master record always ..
SELECT
ASSETUSERCUST.PERSONID,
PERSON.DISPLAYNAME MYNAME,
AUTOATTRUPDATE.ASSET,
ASSET.DESCRIPTION ASSET_DESC,
ASSET.LOCATION,
AUTOATTRUPDATE.WONUM,
WORKORDER.DESCRIPTION WO_DESC,
ASSETATTRIBUTE.DESCRIPTION ATTR_DESC,
AUTOATTRUPDATE.OLDALNVALUE,
AUTOATTRUPDATE.NEWALNVALUE,
AUTOATTRUPDATE.COMPLETEDATETIME
FROM
AUTOATTRUPDATE,
ASSETUSERCUST,
PERSON,
ASSET,
WORKORDER,
ASSETATTRIBUTE
WHERE ASSETUSERCUST.ASSETNUM =AUTOATTRUPDATE.ASSET
and PERSON.PERSONID = ASSETUSERCUST.PERSONID
AND ASSET.ASSETNUM = AUTOATTRUPDATE.ASSET
AND WORKORDER.WONUM = AUTOATTRUPDATE.WONUM
AND AUTOATTRUPDATE.ATTRIBUTE = ASSETATTRIBUTE.ASSETATTRID
and PERSON.PERSONID = ASSETUSERCUST.PERSONID
and 1=1
and asset.assetnum=:assetno
order by ATTR_DESC,AUTOATTRUPDATE.COMPLETEDATETIME
(Master) fields design :
Asset No
Description
Location
Custodian
(Detail) fields design :
WO No.
WO Desc
Attribute Desc
Old Value
New Value
Modify Date
|
|
|
|