Not sure if this will work with MySQL (office uses a different database and
I can't get to real one to test it) but this seems to work:
select t1.name, tot=(t2.col1+t2.col2+t2.col3+t2.col4)
from table1 t1, table2 t2, table3 t3
where t1.id1 = t3.id1
and t2.id2 = t3.id2
order by tot desc
name
Wiley,
there's a comma missing from the end of:
name varchar(50),
Keith
Extranet
[EMAIL PROTECTED] - 08/02/2003 00:52
To:mysql
cc:
Subject:NEWBIE to mysql
Can anyone tell me why I keep getting an ERROR 1064 with this command ?
I just would like to create a table with two
Bhavin,
the documentation says that you use \N to represent null values.
Keith
Extranet
[EMAIL PROTECTED] - 08/02/2003 17:25
To:mysql
cc:
Subject:Help with default NULL
Hi,
I have a table Log described as such:
+--+---+--+-+-+---+
| Field
Lars,
if I understand you correctly:
create table table1
(
hotel_number int
);
create table table2
(
hotel_number int,
free_day datetime
);
insert into table1 values(1);
insert into table1 values(2);
insert into table1 values(3);
insert into table2 values(1,Jan 1 2003);
Are you running mysql or mysql-max? InnoDB is not supported in standard
mysql. If you are running max then are there any error messages?
Extranet
[EMAIL PROTECTED] - 05/02/2003 17:17
To:mysql
cc:
Subject:innodb
I have a small probleme with MySQL in 3.23.55.
I do not manage to
Sadly MySQL does not support sub-selects yet. Take a look at the manual for
suggestions of ways around it.
Keith
Extranet
[EMAIL PROTECTED] - 06/02/2003 02:31
To:mysql
cc:
Subject:Can mysql execute this ? how can i do this ?
Is this possible
select nome from categorias where
