Re: Please help DB Error: unknown error

2003-11-18 Thread Matt W
Hi Thai, I think you're just joining wy 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

Re: Please help DB Error: unknown error

2003-11-18 Thread Reverend Deuce
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

Re: Please help DB Error: unknown error

2003-11-18 Thread Paul DuBois
At 9:10 +0700 11/17/03, Thai Thanh Ha wrote: 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. Joins can join up to 31 tables in MySQL. Looks like you're exceeding that limit. Regards, Thai SELECT

RE: Please help DB Error: unknown error

2003-11-17 Thread Victor Pendleton
Can you please post the error? -Original Message- From: Thai Thanh Ha [mailto:[EMAIL PROTECTED] Sent: Sunday, November 16, 2003 8:10 PM To: '[EMAIL PROTECTED]' 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

RE: Please help DB Error: unknown error

2003-11-17 Thread Thai Thanh Ha
know how to resolve this problem. Regards, Thai -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Monday, November 17, 2003 8:02 PM To: 'Thai Thanh Ha'; '[EMAIL PROTECTED]' Subject: RE: Please help DB Error: unknown error Can you please post the error

Please help DB Error: unknown error

2003-11-16 Thread Thai Thanh Ha
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