List:General Discussion« Previous MessageNext Message »
From:Ian Sales (DBA) Date:February 22 2005 9:13am
Subject:Re: help with an SQL query
View as plain text  
Michael Satterwhite wrote:

> -
> As it is, all I can suggest is to JOIN on all 90 tables - and hope MySQL
> can handle the query - and that you can type all of them without error.
> Note that if you use a UNION query as you suggest above, you will get
> the last login FOR EACH DAY - not the overall last loging.

- MySQL will only allow you to join 32 tables in a single SQL statement.

- ian

-- 
+-------------------------------------------------------------------+
| Ian Sales                                  Database Administrator |
|                                                                   |
|                              "All your database are belong to us" |
| ebuyer                                      http://www.ebuyer.com |
+-------------------------------------------------------------------+

Thread
help with an SQL queryJ S21 Feb
  • Re: help with an SQL queryHarald Fuchs22 Feb
Re: help with an SQL queryJ S21 Feb
  • Re: help with an SQL queryMichael Satterwhite21 Feb
    • Re: help with an SQL queryDBA)22 Feb