title: The multi-part identifier could not be bound
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/2531924/the-multi-part-identifier-could-not-be-bound">The multi-part identifier could not be bound</a>  </p>
  </blockquote>
  
  
  
  <p>This is my query that doesn't want to work.</p>
  
  <p>It says:
  The multi-part identifier "dbo.RunSequenceBatch.RunSequenceBatchName" could not be bound.</p>
  
  <p>Could you please advise?</p>
  
  <p>Thanks in advance!!! :)</p>
  
  <pre><code>SELECT '30 May' AS [Date],
  [RunSeq].[RunSequenceBatchName] AS [Batch Job Name] ,
  RunSeqCat.CategoryDescription AS [Development Name] ,
  [Systems].SystemName AS [System Area] ,
  CAST((SUM(DumpSM37_Env3.Duration) / 60) AS NUMERIC(10, 2)) AS [Duration (mins)] 
  FROM [dbo].[RunSequenceBatch] AS RunSeq 
  LEFT JOIN DumpSM37_Env3 ON ([RunSeq].[RunSequenceBatchName] =  DumpSM37_Env3.[Job] 
  AND DumpSM37_Env3.[ImportDate] BETWEEN  '30 May 2012 00:00:00' AND '30 May 2012 23:59:59'), 
  [dbo].[RunSequenceType] AS RunSeqType, 
  [dbo].[RunSequenceFrequency] AS RunSeqFrequency, 
  RunSequenceCategory AS RunSeqCat, Category, [Systems]  
  WHERE RunSeq.Status = 'Active' 
  AND RunSeqFrequency.RunSequenceBatchID  = RunSeq.RunSequenceBatchID 
  AND RunSeq.RunSequenceTypeID = RunSeqType.RunSequenceTypeID 
  AND RunSeqCat.CategoryDescription = Category.Description 
  AND Category.SystemArea = [Systems].SystemID 
  AND DumpSM37_Env3.[Duration] &gt; 0 
  AND RunSeq.RunSequenceTypeID = 1 
  AND RunSeqCat.RunSequenceBatchID = RunSeq.RunSequenceBatchID  
  GROUP BY dbo.RunSequenceBatch.RunSequenceBatchName, DumpSM37_Env3.WorkerProcessID, 
  ORDER BY [RunSeqFrequency].[Frequency] ASC, 
  [RunSeqFrequency].[StartTime] ASC
  </code></pre>