Struggling to write a view where it populates a dropdown box from a table. 

The dropdown will only show items that have not already been created. In my case its fields in a farm cost programme. 

`$`

```
CREATE VIEW [dbo].[cmbPopulateFieldsnotcosted]
    AS SELECT 
    fieldID,
    fieldName,
    fieldLocation,
    fieldSize,
    fieldHistory
    FROM [fieldDetails]
    where fieldDetails.fieldID not in fieldCosts.fieldID
    inner join fieldCosts.fieldID = fieldDetails.fieldID

```

`$`

[enter image description here](https://i.stack.imgur.com/upDzM.png)
[enter image description here](https://i.stack.imgur.com/kbgid.png)

The two images show the errors I am getting. 

Any help would be appreciated.

Also to give more information, when i already have a field that has had costs added I do not want to be able to add more costs for it. Rather just update it, hence wanting to write this view to allow me to do this.