希望你能帮助我:)
Table client_access:
+-----------------------------------------------+
| id | group_id | email | firstname | lastname |
+-----------------------------------------------+
| 1 | 2 | e@ss.s | john | terry |
+-----------------------------------------------+
| 2 | 1 | b@ss.s | Marie | joli |
+-----------------------------------------------+
Table client_group:
+-----------------------------------------------+
| id | name | descri | color |
+-----------------------------------------------+
| 1 | Gooduser | good users | #000 |
+-----------------------------------------------+
| 2 | Baduser | bad users | #ff0 |
+-----------------------------------------------+
I want Print:
Client: John terry
Group: baduser
Color: #ff0
也许有人可以帮助你创建这个查询?
我做了
SELECT *, (SELECT name FROM client_group WHERE id=o.group_id) AS gname, (SELECT color FROM client_group WHERE id=o.group_id) AS gcolor, (SELECT id FROM hb_client_access WHERE id=o.id) AS guser FROM client_access AS o WHERE id='".$userid."' LIMIT 1
谢谢大家