Bret,
BINGO!
>SELECT nxstar_e.*
> ,nxsprodr.prod_desc
> ,(SELECT Count (id)
> FROM nxsnotes
> WHERE nxsnotes.id = nxstar_e.tar_num) AS Activities
> ,nxsteche.tech_name
>FROM nxstar_e
> ,nxsprodr
> ,nxsteche
>WHERE nxsprodr.prod_code = nxstar_e.prod_id
>AND cust_code = #Cookie.User_ID#
>AND nxstar_e.entered_by *= nxsteche.tech_code /** new line **/
>ORDER BY nxstar_e.tar_num desc
Thanks!
Miles
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
