-
> From: "Mark Rowlands" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, May 17, 2001 3:11
> Subject: create table with select syntax error problem
>
> > CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(10)
&
Original Message -
From: "Mark Rowlands" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 17, 2001 3:11
Subject: create table with select syntax error problem
> CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(
CREATE TABLE Ftt (sajtid smallint(6) DEFAULT '0' NOT NULL,count int(10)
unsigned DEFAULT '0' NOT NULL,PRIMARY KEY (sajtid)) select
log.sajtid,count(*) from log,sajter where log.sajtid=sajter.id and log.mon =
5 group by log.sajtid;
the create table on its own works, the select statement works,
