title: how to make this query executable in mysql?
body: <p>i got this mssql query...
  but then i want to use it in mysql..
  when i executed this query...it said that</p>
  
  <p><strong>Error Code: 1109. Unknown table in MULTI DELETE</strong></p>
  
  <p>from my reading..it maybe related with alias which im using in my query...
  this is my mssql query..hope anyone can help..thank you..</p>
  
  <pre><code>Delete logDetail
  from logDetail ld1
  where 
  -- Absent rows only 
  ld1.L_Time = '00:00:00'
  and ld1.L_Status = 'TIDAK HADIR'
  --  And there must be a COMING or BACK row for the same card on the same day 
  and exists (select 1 from logDetail ld2
   where ld2.L_Date = ld1.L_Date
  and ld2.L_CardID = ld1.L_CardID
  and ld2.L_Time &gt; '00:00:00'
  and ld2.L_Status &lt;&gt; 'TIDAK HADIR')
  </code></pre>