> Hi there > > I have a query where I am getting information from 2 tables. > > Basically a category table i.e. categories are face, body & breasts > > Users have entered details of cosmetic enhancementprocedures according > to whether the procedure is for face, body or breasts, e.g. face has > face lift, rhinoplasty, browlift, Body has liposuction, tummy tuck > etc > > On the site I want to display the information in the respective groups > hence body, face and breasts. > > My query is as follows: > > > SELECT cecat.cecatid, cecat.cecategory, ce.cecategoryid, ce.cename, > ce.cedetails, ce.ceresults > FROM tbl_cosmeticenhancement ce, tbl_cecategories cecat > WHERE ce.cecategoryid = cecat.cecatid > Order by cecat.cecategory > > > Then I was going to have > > > <cfoutput query="qGetCEProcedures" group="cecategory"> > #qGetCEProcedures.cecategory# <br /> <br /> > #qGetCEProcedures.cename#</cfoutput> > > > What I am finding is that I am only getting one result displayed for > each category instead of 3 or 4. > > Thanks in advance for feedback.
Have you tried joining the tables on the shared categoryID values? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285549 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
