I need a little help on an sql oracle SQL statement.
I need to select the rows from one table, where the medlem_nr does not exist in another table. Witch is the fastest way to do that?
I have made this statement that does what i want, but it takes a long time.
select * from medlem where medlem_nr not in (select accountnum from custtable where accountnum = medlem.medlem_nr)
Anyone got a better way?
Yahoo! Groups Sponsor ADVERTISEMENT
click here
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
