<cfquery datasource="askseaton" name="getOffices" result="varibles">
select
address + ' ' + address2 + ' ' + address3 + ',' + city
+ ',' + state + ',' + city as office_address,
(select first + ' ' + last as full from user_info
where user_id =lead_mgr ) as leadmgr, (here if user_id neq lead_mgr i have to
return lead_note column) how to do this.......please help me
(select first + ' ' + last as full from
user_info where user_id = AREA_MGR_RDO ) as director,
(select first + ' ' + last as full from
user_info where user_id = SDIR_NDIR) as SDIRNDIR,
(select first + ' ' + last as full from
user_info where user_id = VICE_PRE ) as VICEPRE,
(select first + ' ' + last as full from
user_info where user_id = FAST_MGR ) as FASTMGR
from sourcebook_1
where active = 1
and office_id not in(36,37,38,73)
order by office_number
</cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324789
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
