OK... Here are my queries..... I need to add 1 more lookup to this but I am sure...
I need to add a lookup to that does this: <CFQUERY name="getsection" datasource="KrisKart"> Select CourseID >From Sections Where Catalog_ID = #Getname.code# </cfquery> I am just unsure as to how to integrate this Query into my existing SQL.... We are currently looking up our WHERE getname.courseID = getcoursename.code Improperly... I have to lookup getname.courseID = getsection.courseID and getsection.courseID = getcoursename.code.... Please help me integrate into this SQL: <CFQUERY name="getname" datasource="careerlearn2"> Select * >From students Where districtID = <cfoutput>#form.users#</cfoutput> and FYear = '#control.fyear#' <cfif '#form.semester#' NEQ 'All'>and semester = '<cfoutput>#form.semester#</cfoutput>'</cfif> Order By LastName </CFQUERY> <cfquery name="getcoursename" datasource="KrisKart"> select category.code as code, category.name as name from Category </cfquery> <cfquery name="queryofquery" dbtype="query"> SELECT getname.courseid as courseid, getname.billed as billed,getname.semester as semester, getname.id as ID, getname.username as username, getname.password as password,getname.firstname AS firstname, getname.lastname AS lastname,getname.email AS email, getname.semester AS semester, getname.fyear as fyear, getcoursename.code as code, getcoursename.name AS course_name FROM getname, getcoursename WHERE getname.courseID = getcoursename.code Order by getname.lastname, getcoursename.name </cfquery> THAKN YOU Kris Pilles Website Manager Western Suffolk BOCES 507 Deer Park Rd., Building C Phone: 631-549-4900 x 267 E-mail: [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4