this query is coming back with a syntax error message it pops to the first FROM section and highlights the IM3 part. Error message though say: Syntax error (missing operator) in query expression 'wo_master_IM3_filter_PE.modify_timestamp=MaxRecord TimeMatch'
SELECT wo_master_IM3_filter_PE.*
FROM wo_master_IM3_filter_PE INNER JOIN (SELECT person_id, MAX(modify_timestamp) AS TimeMatch FROM wo_master_IM3_filter_PE GROUP BY person.id) AS MaxRecord ON (wo_master_IM3_filter_PE.modify_timestamp=MaxRecord TimeMatch) AND wo_master_IM3_filter_PE.person_id = MaxRecord.person_id);
I just do not see what is wrong with it, I know it must be something simple that I am missing.
thank you for your help.
Patty
__._,_.___
Posted by: pattykf@cox.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar