Barry Smith writes: >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) ;
Unfortunately petcolor is not a table. Based upon your prior information I think you are looking for: Select * from pet left join color on pet.petName=color.petName; Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]