For starters look at pet.petName=petcolor.petName Try changing it to. pet.petName=color.petName You are referencing the color table as petcolor.
Thanks, Andrew
From: "Barry ." <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Learner Here Getting Frustraighted Date: Thu, 08 Apr 2004 14:18:10 +0000
Hi
I recently began to work through the Book entitled PHP & MySQL For Dummies and i am currently stuck towards the end of the forth chapter ive done everything as said so in the book but i keep getting an error message. Here is an outline of the problem:
i have 2 tables one pet containing petName and petType other table is color containgin petName and petColor. The code which i keep getting errors on is:
Select * from pet outer join color using (pet.petName=petcolor.petName) ;
Now Ive posted my problem on several forums on the internet and have a wide range to replys suggesting what to do but nothing seems to work.
Can anyone please help me??
Barry Smith
_________________________________________________________________
Find a cheaper internet access deal - choose one to suit you. http://www.msn.co.uk/internetaccess
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Free up your inbox with MSN Hotmail Extra Storage! Multiple plans available. http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm00200362ave/direct/01/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]