select r.REGIONDESC, c.CAMPAIGNNAME, c.DESCRIPTION, c.CAMPAIGNCODE, c.FAMILY, c.CAMPAIGNTYPE, c.STATUS, v.PERIOD, v.GENERATED, 
c.PROJECTEDLAUNCHDATE, c.ACTUALLAUNCHDATE, c.FORECASTBUDGET, c.ACTUALCOST, 
u.USERNAME, NULL, NULL, v.NOTES 
from CAMPAIGN c, VSL_CAMPAIGN v, E_CHANNELREGION r, USERINFO u 
where c.CAMPAIGNID = v.CAMPAIGNID and 
v.E_CHANNELREGIONID = r.E_CHANNELREGIONID and 
v.CAMPAIGNMANAGERID = u.USERID(+) and 
c.CAMPAIGNID = ''
u.USERID(+) 这是什么意思啊?各位。