select exmp.name, sum(exmp.money), sum(exmp_t.money) from exmp
left join exmp as exmp_t on exmp_t.name = exmp.name
where exmp.paymentType = 'Cash' AND exmp_t.paymentType = 'Credit' group by exmp.nameselect name, sum(money) as cash, (select sum(exmp_t.money) from exmp as exmp_t where exmp_t.paymentType = 'Credit' AND exmp_t.name=exmp.name) as credit from exmp where paymentType = 'Cash' group by nameUPDATE table1, table2, ...
SET table1.column1 = expression1,
table2.column2 = expression2,
...
WHERE table1.column = table2.column
AND conditions;.sky-mega-menu li:hover > a,
.sky-mega-menu li.current > a {
background: #7FBB66;
-webkit-transform: scale(1.3);
-moz-transform: scale(1.3);
-ms-transform: scale(1.3);
-o-transform: scale(1.3);
transform: scale(1.3);
opacity: 1; /* было opacity: 0; */
color: #ffffff;
}$('select#country').change(function() {
var value = $(this).val();
if(value=='ru'){
$('input[type="text"]').attr('id', 'phone1');
$('input[type="text"]').attr('disabled', false);
}else if(value=='ua'){
$('input[type="text"]').attr('id', 'phone2');
$('input[type="text"]').attr('disabled', false);
}else{
$('input[type="text"]').attr('disabled', true);
}
});$que = mysql_query("SELECT * FROM friends WHERE idaut='$login' and frilog='$myrow[login]' and ban='1'");