Hi guys,

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:

SELECT u.UserID
FROM table1 u,
table2 r,
table3 s,
table4 t,
table5 g
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.

Thanks,
- Gary