>As far as the iciwhs.citemno+iciwhs.cwarehouse= sostrs.citemno+sostrs.cwarehouse is concerned, the compiler doesn't complain about it, and it runs. SQL Server seems to support the + operator in the statement. I haven't tested to make sure it returns the same results as doing it as: >iciwhs.citemno = sostrs.citemno AND iciwhs.cwarehouse= sostrs.cwarehouse > >but I'll check. Am I confused here? Shouldn't these statements be equivalent?
They would produce the same result set but in the second case SQL Server could use indexes to optimize query.