- Forwarded by Peter J. Milanese/MHT/Nypl on 06/05/2003 07:35 AM -
Peter J. Milanese
06/04/2003 09:55 PM
To: Peter J. Milanese/MHT/Nypl
cc: "Mike Hillyer" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: RE: Suggestions on joins/me
[EMAIL PROTECTED]
Subject: RE: Suggestions on joins/merges
Well
I was thinking about that...
However-
select sum(value) from
stats_picturecollection_nypl_org.0403_detail,stats_picturecollection_nyp
l_org.0503_detail,stats_picturecollection_nypl_org.0603_detail where
epoch between 1050
lues?
P
"Mike Hillyer" <[EMAIL PROTECTED]>
06/02/2003 03:04 PM
To: "Peter J. Milanese" <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
Subject:RE: Suggestions on joins/merges
Ok...
select ref.zipcodes.
by count DESC
limit 10
That should do it, right?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Peter J. Milanese [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 12:23 PM
To: Mike Hillyer
Cc: [EMAIL PROTECTED]
Subject: RE: Suggestions on joins/merges
, <[EMAIL PROTECTED]>
cc:
Subject: RE: Suggestions on joins/merges
What column is MySQL complaining about being ambiguous? Isn't it just a
matter of adding tablename. To the start of the guilty column?
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Peter
L PROTECTED]
Sent: Monday, June 02, 2003 11:25 AM
To: [EMAIL PROTECTED]
Subject: Suggestions on joins/merges
Greetings:
I have a series of large tables. 5+gb each.
They have identical structures.
Sample of the query I want to run:
select ref.zipcodes.state as state, count(1) as count fro
EMAIL PROTECTED]
Subject: Suggestions on joins/merges
Greetings:
I have a series of large tables. 5+gb each.
They have identical structures.
Sample of the query I want to run:
select ref.zipcodes.state as state, count(1) as count from
BIGTABLE,BIGTABLE2,BIGTABLE3,ref.zipcodes where tsb between $Star
Greetings:
I have a series of large tables. 5+gb each.
They have identical structures.
Sample of the query I want to run:
select ref.zipcodes.state as state, count(1) as count from
BIGTABLE,BIGTABLE2,BIGTABLE3,ref.zipcodes where tsb between $Start and $End
and zipcode=ref.zipcodes.zipcode group
