Displaying 1 result from an estimated 1 matches for "classification_level".
2006 Jul 21
0
[Slightly OT] Need Query Help
....f_name AS f_name, c.l_name AS l_name, c.gender AS gender,
c.race AS race, c.dob AS dob, c.address 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_typ...