Roger Baklund wrote:
Try something like this:
SELECT ID,NAME,COUNT(*)
FROM tableA
LEFT JOIN tableB ON
tableA.ID = tableB.ID
GROUP BY ID,NAME
Nope, sorry, that won't work, ID exists in both tables thus it must be
prefixed with table name or alias: SELECT tableA.ID,... GROUP BY
tableA.ID,
Joppe A wrote:
hello all,
I am a newbe working with MySQL.
I have a problem that I can't figure out how to do.
I have 2 tables that I want to take out data from, the tables looks
like below.
tableA
==
ID VARCHAR(12)
NAMEVARCHAR(255)
CREATED TIMESTAMP
tableB
==
"Joppe A" <[EMAIL PROTECTED]> wrote on 02/17/2005 09:45:31 AM:
> hello all,
> I am a newbe working with MySQL.
> I have a problem that I can't figure out how to do.
>
> I have 2 tables that I want to take out data from, the tables looks
> like below.
>
> tableA
> ==
> ID VARCHA
