RE: Error ?

[Garth Webb]

Your join syntax is incorrect.  Check out:

    http://dev.mysql.com/doc/mysql/en/JOIN.html

In particular, you join against an alias (t2), when you need to join on
an actual table.

On Thu, 2004-04-15 at 14:25, Justin Palmer wrote:
> 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]
> 
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
> 
> 
-- 

 |- Garth Webb       -|
 |- [EMAIL PROTECTED] -|

signature.asc
Description: This is a digitally signed message part