RobsoN
18th March 2014, 21:23
Hello, Im new in SQL. I want to get in one query: reason, banned NAME, admin NAME (thats missing in my query - i need this :P), ban type, time_add, time_expire, type. My current query looks like this:
SELECT p.id, p.type, p.client_id, p.time_expire, p.time_add, p.reason AS ban_reason, c.name AS banned_client, p.admin_id AS banned_by FROM penalties p, clients c WHERE (p.inactive = '0' AND (p.time_expire > UNIX_TIMESTAMP() OR p.time_expire < 1)) AND (p.type = 'TempBan' OR p.type = 'Ban') AND c.id = p.client_id
As you can see, I got 2 tables.
1st table "clients" with id, name (...)
2nd table "penalties" with client_id, admin_id, time_add, reason, type
I dont know how can I get names (admin name + banned name) in one query, knowning only clients ids ..:confused:
Thanks in advice.
Regards RobsoN.
SELECT p.id, p.type, p.client_id, p.time_expire, p.time_add, p.reason AS ban_reason, c.name AS banned_client, p.admin_id AS banned_by FROM penalties p, clients c WHERE (p.inactive = '0' AND (p.time_expire > UNIX_TIMESTAMP() OR p.time_expire < 1)) AND (p.type = 'TempBan' OR p.type = 'Ban') AND c.id = p.client_id
As you can see, I got 2 tables.
1st table "clients" with id, name (...)
2nd table "penalties" with client_id, admin_id, time_add, reason, type
I dont know how can I get names (admin name + banned name) in one query, knowning only clients ids ..:confused:
Thanks in advice.
Regards RobsoN.