I don't understand why my query is hanging. I have five tables with about 100 rows in each. All I'm trying to do is determine if a specific user exsits in any of the tables provided:
FROM table1 u,
where r.userid = 1
or s.userid = 1
or t.userid = 1
or g.userid = 1
When I use three paramaters on the WHERE clause, it works fine. But when I use more than three, it just hangs.
Any help would be greatly appreciated.
Click Here to Expand Forum to Full Width