Help with lookml/sql

[conor-flan]

I’m trying to create this SE name field in looker. It exists on the opportunity table/view. I want to bring in ‘Name’ from the user table when ‘se assigned’ = Id. 

It’s a simple vlookup in excel, but am not sure how to pull this into looker. HEre is the code I’m going with below

  dimension: se_name {
    type: string
    sql: SELECT FULL_NAME_C FROM "PROD_SALESFORCE" . "USER"  WHERE ${se_assigned} = ID   ;;
  }