I've very basic SQL experience and have been stuck with this SQL problem for a few days.
I've 2 tables. I need to move 3 columns of info from one table to the other. 

Table A, the table I'm moving info into has 8 columns 3 of which is set to not accept null values.

how can I move over just the 3 columns and skip over or insert '0' into the column's that require values?

I'm using MS SQL server 2005 express.
This is what I have so far: 

```
INSERT INTO account (sSurname, sName, sIdNo)
SELECT Client.LASTNAME, Client.FIRSTNAME, Client.DATEOFBIRTH
FROM Client
INNER JOIN Account__MEMBER
ON Account__MEMBER.AccountKEY=Client.AccountKEY
ORDER BY Client.LASTNAME;

```

I've tried to research this but have not come across anything useful.