SELECT DISTINCT V.VENDOR,R.ADDRNUM, V.VNAMEL, R.AADDR1,P.BILLTO,R.ACITY, R.ASTATE,
R.AZIPCODE,R.VASST1,R.APHONE,J.ROUTE,L.LETTING, L.CALL,Q.CPROJNUM,Q.CFACSSUP,Q.CCNTY1
FROM VENDOR V, VENDADDR R, LETPROP L, PLANHOLD P,PROPOSAL Q, PROJECT J,PROPPROJ K
WHERE V.VENDOR = R.VENDOR
AND K.CONTID = Q.CONTID
AND K.PCN = J.PCN
AND L.LCONTID = K.CONTID
AND P.VENDOR = V. VENDOR
AND L.LETTING = P.LETTING
AND L.CALL = P.CALL
AND R.ADDRNUM = P.BILLTO;
As you can see from the above query i am missing "L.LCONTID" field and i would like to add this field to the view that i have created and I created the view again including the field that i want to include.
My question is when i want to add this new field to the report i created before the new field "L.LCONTID" is no where to be found.I do not know where i made a mistake.if someone has any idea how i could make this field to be appear on my report. thank you again.I am using oracle 9i as my database and CR 8.5