I'm trying to make a query which selects all rows that are not linked to the a certain number, i already managed to do this with a subquery, but this slows down the application, mainly caused because i have more then 100k rows.
Expand|Select|Wrap|Line Numbers
- (simplefied) table
- ############################
- # RowId # MessageId # Type #
- ############################
- # 1 # 104 # 3 #
- # 2 # 104 # 3 #
- # 3 # 104 # 4 #
- # 4 # 104 # 5 #
- # 5 # 104 # 4 #
- # 6 # 104 # 8 #
- # 7 # 105 # 3 #
- # 8 # 105 # 2 #
- # 9 # 105 # 1 #
- # 10 # 106 # 4 #
- # 11 # 106 # 3 #
- # 12 # 107 # 4 #
- # 13 # 107 # 6 #
- # 14 # 107 # 5 #
- # 15 # 107 # 9 #
- ############################
is there any way to do this without a subquery?
Greetz Daanoz