Octavian,
You seem to be missing an articles column linking it to newspapers.
Supposing an id_newspapers column in articles, your query would be
something like
SELECT
articles.title,
CHAR_LENGTH(body) AS Length,
newspapers.name AS Newspaper,
COUNT(visitors.id) AS Visits,
COUNT(comments.i
Hi,
just Start here http://dev.mysql.com/doc/mysql/en/select.html
mathias
Selon Octavian Rasnita <[EMAIL PROTECTED]>:
> Hi,
>
> I have the following tables:
>
> create table articles(
> id int unsigned not null primary key,
> title varchar(255) not null,
> body text not null
> );
>
> create tab
Hi,
I have the following tables:
create table articles(
id int unsigned not null primary key,
title varchar(255) not null,
body text not null
);
create table newspapers(
id int unsigned not null primary key,
name varchar(255) not null
);
create table visitors(
id int unsigned not null primary k