Welcome Guest, Not a member yet? Register   Sign In
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




Theme © iAndrew 2016 - Forum software by © MyBB