Re: [GENERAL] stupid select question...

2001-01-14 Thread Oliver Elphick
Konstantinos Agouros wrote: > >Hi, > >my sql has gotten a little rusty, here's what I want to do: >I have two tables both contain urls. How what I want are all the entries in >table b where there is no matching url in table a. I do remember doing somet >hing >like this with a

[GENERAL] stupid select question...

2001-01-14 Thread Konstantinos Agouros
Hi, my sql has gotten a little rusty, here's what I want to do: I have two tables both contain urls. How what I want are all the entries in table b where there is no matching url in table a. I do remember doing something like this with a select url from table1 where a.url not in select url from