query result mistake:
SELECT name,unit_amount,date FROM account_analytic_line
WHERE account_id=100 AND user_id=2 AND id IN
SELECT hat.line_id FROM hr_analytic_timesheet as hat,project_task_work as ptw
WHERE hat.issue_id is null AND line_id not in(
select ptw.hr_analytic_timesheet_id from project_task_work as ptw,hr_analytic_timesheet as hatt
where ptw.hr_analytic_timesheet_id=hatt.line_id and ptw.user_id=2)
please help me..................................
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 10/28/15, 7:58 AM|
|Seen: 172 times|
|Last updated: 10/28/15, 7:59 AM|