Unable to perform Inner Join

[Ben Smith]

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/my***********...ie.nctu.edu.tw