MYSQL само ако ги има и двете ..

[sentenello]

Здравейте, заявката ми представлява това
[sql]SELECT mach.darjava as country,
mach.datata as data,
TIME (mach.datata) as startovchas,
DATE(mach.datata) as startovadata,
mach.id as matchid ,
Concat(mach.domakin, ' - ', mach.gost) AS teams,
Group_concat(res.tipzalog order by res.tipzalog DESC SEPARATOR '_') as zaloga,
Group_concat(res.domgol order by res.domgol ASC SEPARATOR '_') as domgol,
Group_concat(res.gostgol order by res.gostgol ASC SEPARATOR '_') as gostgol
FROM `resmatch` mach
LEFT JOIN `reszalog` res ON mach.id = res.machid
WHERE mach.id = res.machid
AND res.domgol !='Any Unquoted'
AND res.gostgol !='Any Unquoted'
GROUP by mach.id
ORDER BY darjava ASC , `datata` ASC[/sql]

Виждате че групирам tipzalog , но някой път имам само ред с tipzalog и вместо да стане
Correct Score_Half Time Score, то става само Correct Score.. Въпроса ми е как да задам на тази заявка да взема мачовете с ид който имат и двата реда.

 

[raiden]

INNER JOIN вместо LEFT JOIN ?

 

[sentenello]

Можеш ли да ми дадеш някакъв пример ?

 

[jooorooo]

[sql]SELECT mach.darjava as country,
mach.datata as data,
TIME (mach.datata) as startovchas,
DATE(mach.datata) as startovadata,
mach.id as matchid ,
Concat(mach.domakin, ' - ', mach.gost) AS teams,
Group_concat(res.tipzalog order by res.tipzalog DESC SEPARATOR '_') as zaloga,
Group_concat(res.domgol order by res.domgol ASC SEPARATOR '_') as domgol,
Group_concat(res.gostgol order by res.gostgol ASC SEPARATOR '_') as gostgol
FROM `resmatch` mach
INNER JOIN `reszalog` res ON mach.id = res.machid
WHERE mach.id = res.machid
AND res.domgol !='Any Unquoted'
AND res.gostgol !='Any Unquoted'
GROUP by mach.id
ORDER BY darjava ASC , `datata` ASC[/sql]