nested select and update

[bluebytez]

Hi, I have a problem with a database which I have imported from a text file.
In one of my tables, there are more a few rows for each staff. The problem is, the data for one of the columns ( i.e. Age ) only exists in the first row of the same staff. How do I make a SQL statement to fill the other rows belonging to the same staff with the data from the first row ?
I hope I have not confused anyone.
Thanks for your help !

 

[fluteplr]

If I understand your question.

update staff1 set age = staff2.age
from staff staff1, staff staff2 where
staff1.staffid = staff2.staffid and
staff1.age is null and staff2.age is not null

if the missing data is not null replace the null check with whatever would be appropriate for the missing data.