Re: Yet another newbie question
Date: Thu, 3 Sep 2009 08:19:45 -0700 (PDT)
Thanks for the pointers, guys.
This is what I've come up with:
set a.col1 = 'something'
where a.col2>=b.col2 and a.col3<=b.col3 )
Is my syntax correct for what I'm aiming to do? As for what I'm aiming to do, I hope it's clear.
I have two tables, A and B and a column in A needs to be updated to true if two columns in A (source and destination) fall in a range, given that all ranges are in table B as two columns (start and end).
And the syntax I quoted is from Sybase, which is where I acquired it.
Sashi Received on Thu Sep 03 2009 - 10:19:45 CDT