Help with SELECT statement

single select with join. i rarely use select from where x in (select x from where). if your table is big and a join is slow, check you have an appropriate index on the table eg on downtime table you'd have an index on eventid (key), deviceid and componentid

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.