This question has been flagged
1977 Views

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

Avatar
Discard