forum.lissyara.su

Код: Выделить всё

тарифные планы:
+-------+---------------+
| tp_id | name          |
+-------+---------------+
|     1 | 256Kbit_unlim |
|     2 | chasn_400rub  |
|     3 | chasn_500rub  |
|     4 | chasn_1200rub |
|     5 | chasn_1900rub |
|     6 | org_600rub    |
|     7 | org_1350rub   |
|     8 | org_2160rub   |
|     9 | org_4050rub   |
|    10 | 10Mbit_unlim  |
+-------+---------------+

счета:
+----+-------------+-----+
| id | ballance    | uid |
+----+-------------+-----+
|  1 |  -33.840290 |   1 |
|  2 |    0.000000 |   2 |
|  3 | -661.363052 |   3 |
|  4 |  100.000000 |   4 |
|  5 |    0.000000 |   5 |
+----+-------------+-----+


пользователи:
+-------------+---------+-----+
| id          | credit  | uid |
+-------------+---------+-----+
| test1       | 1000.00 |   1 |
| andrey_test |  100.00 |   2 |
| denis       | 1000.00 |   3 |
| katerina    | 1399.00 |   4 |
| nkk         |    1.00 |   5 |
+-------------+---------+-----+


настройки:
+-----+-------+
| uid | tp_id |
+-----+-------+
|   1 |     2 |
|   3 |     2 |
|   4 |    10 |
|   5 |     1 |
+-----+-------+

Код: Выделить всё

SELECT
	usr.uid,
	usr.id,
	bln.ballance,
	usr.credit,
	trf.name

FROM 
	пользователи usr
		LEFT JOIN настройки stn ON stn.uid = usr.uid
		LEFT JOIN тарифные планы trf ON trf.tp_id = stn.tp_id
		LEFT JOIN счета bln ON bln.uid = usr.uid