daniel kessler wrote: > 1 - I'm not so good at sql and the join only works if there's an id in the > approved_by field. This is going to be empty unless the ticket has been > approved, but I still want it to work whether it's approved or not. Is that > an outter join? > Yes it will be an LEFT or RIGHT outer join. The direction determines which table you want ALL records from. So if the expense table is on the left of the join use expense LEFT OUTER JOIN people on aField = bField. If yo want it on the right then it would be people RIGHT OTER JOIN expense on aField = bField.
> 2. Currently, I do p.fname AS approved_by_fname,p.fname AS > approved_by_lname. I'd like it to be one variable though, but I'm not sure > how to format p.fname + p.lname AS approved_by_name. > In Oracle '||' is the concatenate operator so it would be p.fname || ' ' || p.lname AS approved_by_name. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
