SELECT *, tbl2.id AS id_file FROM tbl1 JOIN tbl2 ON условие
$result = mysql_query("SELECT id,address,phone,delivery_id FROM s_orders WHERE status = '0' AND paid = '1' AND delivery_id != '5' ORDER BY phone");
if ($result) {
while ($row = mysql_fetch_assoc($result)) {
// Обработка строк...
}
}
SELECT
wc.id,
wc.caption,
COUNT(wb.*) AS billcount
INNER JOIN
wmail_order AS wo ON wo.company_id = wc.id
INNER JOIN
wmail_comm_bill AS wb ON wb.order_id = wo.id
FROM
wmail_company AS wc
GROUP BY
wc.id
ORDER BY
billcount DESC
LIMIT 0, 50
SELECT SUM(am3.value) FROM
(
SELECT am2.id, am2.value
FROM auditors_audiences_map AS am2
LEFT JOIN audiences_range_map AS a2 ON (a2.value BETWEEN 13 AND 17)
WHERE am2.audience_id=a2.audience_id
GROUP BY am2.audience_id
) AS am3