thanks so much

Jan Van der Eecken (3/31/2013)

---

Great to hear you got it working. But please remember next time around you ask a question to please provide us with enough info to actually...

Now working, thank you.

SELECT Coalesce( sGIG, 'Tot' ) as sGIG, Sum(Number) as Num

FROM (

SELECT LEFT (idDGIG, 2) AS sGIG, COUNT(idDGIG) AS NUMBER

FROM TABLE_LONG

WHERE

...

Lynn Pettis (3/28/2013)

---

Start with something like this:

select

idDGIG,

count(idDGIG) as Number

FROM (

SELECT

LEFT (idDGIG, 2) AS idDGIG,

...

mrivero1961 (3/28/2013)

---

Sean Lange (3/28/2013)

---

This is MySql. If you want to join multiple queries together you probably need to use UNION.

I really can't tell from what you have posted what the...

Sean Lange (3/28/2013)

---

This is MySql. If you want to join multiple queries together you probably need to use UNION.

I really can't tell from what you have posted what the actual...

Sean Lange (3/28/2013)

---

mrivero1961 (3/28/2013)

---

Thank you for help.

I've modified the query, but the output not change:

SELECT

DATE_START,

COALESCE (idDGIG, 'Tot') AS sGIG,

`NUMBER`

FROM

(

SELECT

CA.DATE_START AS DATE_START,

LEFT (CA.idDGIG, 2) AS sGIG,

COUNT(CA.idDGIG) + COUNT(A.EVENT) AS NUMBER

FROM

TABLE_LONG...

Thank you for help.

I've modified the query, but the output not change:

SELECT

DATE_START,

COALESCE (idDGIG, 'Tot') AS sGIG,

`NUMBER`

FROM

(

SELECT

CA.DATE_START AS DATE_START,

LEFT (CA.idDGIG, 2) AS sGIG,

COUNT(CA.idDGIG) + COUNT(A.EVENT) AS NUMBER

FROM

TABLE_LONG CA

JOIN TABLE_SHORT A...

Thank you very much, now working!!! 😀

SELECT

A.ID,

A.connected,

B.id,

B.connected,

A.datum,

B.datum_update,

A.title,

A.author,

B.message,

B.last_replies

FROM

forums a

LEFT OUTER JOIN forums b...

thank you for help, but the output is incorrect:

SELECT

A.ID,

A.connected,

B.id,

B.connected,

A.datum,

B.datum_update,

A.title,

A.author,

B.message,

B.last_replies

FROM

forums a

LEFT OUTER JOIN forums...