Hi there,
here is what I am trying to do:
I am filling a drop down box from the users table:
<cfquery name="Users" datasource="mysource">
select USERNAME from users where users.user_department='HR'
</cfquery>
This works fine but i also need to add to the list the users from sales....How do i...