sql syntax

by Susan Bishop <aka_susanb(at)yahoo.com>

 Date:  Mon, 11 Dec 2000 10:25:25 -0800 (PST)
 To:  hwg-languages(at)hwg.org
  todo: View Thread, Original
I am trying to figure out the correct way to update a
column based on another columns.

I nned to move the values from 3 columns into one
column.  I.e. 

column 1 = college
column 2 = child
column 3 = <null> (or a value)

into one column

column a = college, child ...


Any ideas ?


__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA