Help with SELECT statement

#11
[eluser]bgreene[/eluser]
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-2019 MyBB Group.