> Adtrack - holds data about an ads status (but NOT page number) > Dummy - holds data about ad position, geometry and page number > Stories - holds data about stories and their page number > Pages - holds data about pages and their status > > I want to be able to display a page and all its associated pieces but > without duplicates. I know a union would display what I want, > but I can't > get all the necessary data without doing a join. > > The current query is: > > SELECT > dummy.page_number,dummy.ad_num,adtrack.ad_status,stories.story > _name,stories. > story_status FROM adtrack,dummy,stories WHERE adtrack.ad_num > = dummy.ad_num > AND dummy.page_number = stories.page_number order by > dummy.page_number ASC"
What about this? SELECT dummy.page_number,stories.story_name,stories.story_status FROM dummy,stories WHERE dummy.page_number = stories.page_number UNION SELECT dummy.page_number,dummy.ad_num,adtrack.ad_status FROM adtrack,dummy WHERE adtrack.ad_num = dummy.ad_num order by 1 ASC" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]