Hi All;
I recieved an e-mail as part of a PHP user group mailing list, does anyone
know the answer?
----cut here----
Ok, I know that you can do a ( ) in a query for working stuff but can you do
another query there? ie
select * from "Activity"
join
(
select "License Number", max("Activity Date") from
"Activity"
where
"Agency" = 'OGC' and
"Posted" >= '2003-01-01'
and (
"Activity" = 'RIG RELEASED' or
"Activity" = 'RESUMED' or
"Activity" = 'SUSPENDED' or
"Activity" = 'CANCELLED' or
"Activity" = 'DRILLING' or
"Activity" = 'PREP TO SPUD'
)
group by "License Number"
having max("Activity Date") >= '2003-01-01'
) AS T1
ON
"Activity"."License Number" = "T1"."License Number" and
"Activity"."Activity Date" = "T1"."Activity Date"
----cut here----
Any help would be appreciated.
Thanks,
Mike Hillyer
http://www.dynamergy.com/mike
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
