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..................................