[Deepblue]

Even better.

[Goober5000]

Don't spend all your money on EverQuest then.

[Kazan]

rotfl i'm actually kidna growing tired of everquest.. i play it like once per week

[Kamikaze]

'grats! As far as income drain goes, watch out for SOs too.

[Kazan]

heh.. blair isn't a very big of an income drain

this is a brain drain

Code: [Select]


SELECT DISTINCT
count(f.`fid`) as c,
e1.`name` as start_text,
e2.`name` as end_text
FROM forms as f
LEFT OUTER JOIN grantees as g ON `f`.`project_number`=`g`.`ed_id`
LEFT OUTER JOIN employment as e1 ON f.`entry_head_employlvl`=e1.`ed_id`
LEFT OUTER JOIN employment as e2 ON f.`exit_head_employlvl`=e2.`ed_id`
WHERE
f.`entry_head_employlvl` IS NOT NULL AND
f.`exit_head_employlvl` IS NOT NULL AND
f.`entry_head_employlvl` != f.`exit_head_employlvl` AND
(enroll > STR_TO_DATE('2004-01-01', '%Y-%m-%d') OR
    exitdate > STR_TO_DATE('2004-01-01', '%Y-%m-%d')) &&
(exitdate < STR_TO_DATE('2005-01-01', '%Y-%m-%d') OR
   enroll < STR_TO_DATE('2005-01-01', '%Y-%m-%d')) AND
(g.`name` LIKE '%Iowa%' OR
   fadss_spec LIKE '%Iowa%')
GROUP BY
 f.`entry_head_employlvl`, f.`exit_head_employlvl`


that's a query i wrote for work

[IPAndrews]

Nice job. PHP and MySQL are incredibly easy, and fun.

[Kazan]

yeah... except when you write skull-splitting sql queries