I'd use something like this for the query. select t1.name, t2.wkid, t2.title from Table2 t2 left join Table1 t1 on t1.WKID = t2.WKID
On Thu, Jan 13, 2011 at 8:15 PM, Frank Liu <fliu2...@gmail.com> wrote: > > Hello > I am new to coldfusion. Please help > > In Table1, I have something like this: > > WKID Name > 1002 High School > > In Table2, I have something like this: > WKID Title > 1002 Math Tecaher > 1002 Science Teacher > 1002 English Teacher > (more) (more) > > I need output to be like this: > > WKID: 1002 > Name: High School > Title: > Math Teacher > Science Teacher > English Teacher > .... (more) > > I have problem with output table2. > Thank you. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340819 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm