Quote:
Originally Posted by GrouchyAdmin
select * into db2 from db1 where (id <= 201 and id >= 1000)?
|
Won't work if the IDs that are in one but not the other aren't sequential
Have to use a join (right, left, outer, whatever way you prefer hehe) in that case.
EDIT: My bad, he did say they are starting with 201 heh. So nevermind.