G'day Jim > What about this? €€€€ That's it, thanks!
I'll be fiddling a bit to get a few other columns but so far this seems be be what I want. The only book I have which handles Unions is the MySQL Cookbook (Paul Dubois) and the examples didn't include any 'where' clauses so I didn't realise they could be used in Unions - dumb of me in retrospect. > 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" Cheers and thanks again - much appreciated kim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]