I have two tables I am trying to join, one is a header and one is the links under that header.
header table: id, header links table id, headerid, link, link_title I am writing a join query to pull up all the headers and the links that go with a particular header, but I if there are no links associated with the header, it won't display anything. I want it to show the headers with 0 links or with 100 links associated. Query is: <cfquery datasource="#prefs.dsn#" name="header"> select h.id, h.header, l.link, l.link_title from headers h, links l where f.sub_object = l.headerid and f.sub_object = h.id group by h.header, f.state, f.sort, l.link, l.link_title, h.id </cfquery> Any help would be appreciated. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector Commerce Builder ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists