not an easy script but worked thanks.

ci_employee ---tables name

emp_id emp_birth_date

1001 1978-04-25

1002 ...

Employee Table ---Table's name

emp_Id emp_birth_date

1001 1978-04-25

1002 ...

Employee Table ---Table's name

emp_Id emp_birth_date

1001 1978-04-25

1002 ...

hi,

cant you use an example using my table details? I do understand alias but not in the manner used here.

thanks.

hi,

cant u use my table example? where are u getting the "a" (the first update statement)from ?

hi SSChampion

can't you write the script using my table example? I do not know where u getting the "a" (first update statement)from. please use my example.

thanks

Chuene.

yes, the answer was a query (select) statement not a script (update). i need an update statement.

giving an error message (Incorrect syntax near the keyword 'AS')

giving an error message (Incorrect syntax near the keyword 'AS')

great yet simple sql query/script.....thanks. mind explaining a bit.