How to you perform multiple queries after the where clause
Instead of running several and statements do you use other statements that perform more efficiently? Right now in one of my queries I have a query with a select statement with alias and several inner joins, however at the where clause all I can come up with product = 'string' and id = 123456 and startdate >= '01/01/2013 and enddate <= '12/31/2013'; Do you think a sub query with (select max would be a better way to go? Any ideas? Thanks!