Try this instead: SELECT pubishers.pub_id, titles.pub_ID FROM pubishers JOIN titles ON pubishers.pub_id = titles.pub_id
HTH. ** For great Emap magazine subscription & gift offers visit http://www.emapmagazines.co.uk ** -------------------------------------------------------------------------------- The information in this email is intended only for the addressee(s) named above. Access to this email by anyone else is unauthorised. If you are not the intended recipient of this message any disclosure, copying, distribution or any action taken in reliance on it is prohibited and may be unlawful. Emap plc and or its subsidiaries do not warrant that any attachments are free from viruses or other defects and accept no liability for any losses resulting from infected email transmissions. Please note that any views expressed in this email may be those of the originator and do not necessarily reflect those of this organisation. -------------------------------------------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
