General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
table1.costctr needs to be converted to a new value. If have put the pseudo code below but would like to do it in an SQL statement.
if table1.costctr = costctr.o_costctr and
control.site_id = costctr.site_id
replace table1.costctr with costctr.n_costctr
endif
table1 has about 1000 records, and a couple hundred fiels
costctr has about 8000 records and only a couple of fields
control has only 1 record and only a couple of fields
thanks
Brenda
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only