Typically, this is the kind of query I see at MS-SQL houses. :) -- R. Deuce
----- Original Message ----- From: "Matt W" <[EMAIL PROTECTED]> To: "Thai Thanh Ha" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, November 18, 2003 5:28 PM Subject: Re: Please help DB Error: unknown error > Hi Thai, > > I think you're just joining waaaay too many tables! LOL > > > Matt > > > ----- Original Message ----- > From: "Thai Thanh Ha" > Sent: Sunday, November 16, 2003 8:10 PM > Subject: Please help DB Error: unknown error > > > > Hi all, > > I have a problem with my query on mySQL 4.0. > > DB Error: unknown error > > I don't know what is the problem. Please help me!!! Thanks in advance. > > Regards, > > Thai > > SELECT t.UserID, t.Country, t.Zip FROM tblUser t, tblUserProfile > > t1,tblUserProfile t2,tblUserProfile t3,tblUserProfile > t4,tblUserProfile > > t5,tblUserProfile t6,tblUserProfile t7,tblUserProfile > t8,tblUserProfile > > t9,tblUserProfile t10,tblUserProfile t11,tblUserProfile > t12,tblUserProfile > > t13,tblUserProfile t14,tblUserProfile t15,tblUserProfile > t16,tblUserProfile > > t17,tblUserProfile t18,tblUserProfile t19,tblUserProfile > t20,tblUserProfile > > t21,tblUserProfile t22,tblUserProfile t23,tblUserProfile > t24,tblUserProfile > > t25,tblUserProfile t26,tblUserProfile t27,tblUserProfile > t28,tblUserProfile > > t29,tblUserProfile t30,tblUserProfile t31,tblUserProfile > t32,tblUserProfile > > t33,tblUserProfile t34,tblUserProfile t35,tblUserProfile > t36,tblUserProfile > > t37,tblUserProfile t38,tblUserProfile t39,tblUserProfile > t40,tblUserProfile > > t41,tblUserProfile t42,tblUserProfile t43,tblUserProfile > t44,tblUserProfile > > t45,tblUserProfile t46,tblUserProfile t47,tblUserProfile > t48,tblUserProfile > > t49,tblUserProfile t50,tblUserProfile t51,tblUserProfile > t52,tblUserProfile ... snip ... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]