Displaying 1 result from an estimated 1 matches for "max_jail".
Did you mean:
max_avail
2006 Jul 21
0
[Slightly OT] Need Query Help
...dress AS address, c.city AS
city,
c.state AS state, c.zipcode AS zipcode, m.date_of_arrest AS
date_of_arrest,
ch.name AS charge_name, t.classification AS charge_type,
t.classification_level AS charge_level, t.max_fine AS max_fine,
t.min_jail_time AS min_jail, t.max_jail_time AS max_jail
FROM clients AS c
LEFT JOIN matters AS m ON c.id = m.client_id
LEFT JOIN charges AS ch ON m.charge_id = ch.id
LEFT JOIN charge_types AS t ON ch.charge_type_id = t.id
This query retrieves all records for each client. I only want 1 record
per c...