Hello Henry,
Wednesday, July 16, 2003, 5:35:49 PM, you wrote:
I've noticed 2 errors.
First: You describe table with name: PUBLISHER but useing in SQL table
PUBISHER - missing a letter "L"
Second: As I'm understanding you want to make join table PUBLISHER
with table TITLES. But see what you wrote
Hi Henry,
You created an alias for a table columnname. But either you
either you created the alias twice with the same name or you are refering to
two columns (one in each table with the same name).
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 16日 水曜日 23:35、Henry さんは書きました:
> I have 2 table
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 **
I have 2 tables with the following fields :
table : publisher
field1: pub_id - Primary, int, auto
table : titles
field1: title_id - Primary, int, auto
field1: pub_id - int
Using sqlyog I noticed that the indexes had already been created for the
Primary keys but according to my tutorial I also h