Sounds to me like it doesn't the the alias name T2 but might need the full table name.
> Hi, > > Can anyone give me a hint to what this error message is trying to say. > > Thanks, > > Justin Palmer > > > -----Original Message----- > From: Justin Palmer [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 15, 2004 1:38 PM > To: [EMAIL PROTECTED] > Subject: FW: Error ? > > > The query that generated this error was: > > SELECT t1. * > FROM `wat_student_profile` AS t1, `wat_student_job` AS t2 > LEFT JOIN t2 ON t1.student_id = t2.student_id > WHERE t1.cv != '' AND t1.sevis_id = '' AND t2.student_id = NULL > LIMIT 0 , 30 > > Regards, > > Justin Palmer > > > -----Original Message----- > From: Justin Palmer [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 15, 2004 1:28 PM > To: [EMAIL PROTECTED] > Subject: Error ? > > > Hi, > > I get this error from a query: > > #1066 - Not unique table/alias: 't2' > > What does it mean? Can anyone point me to a place where I can look up > what these codes actually mean? > > Any help would be great. > > Regards, > > Justin Palmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
