I am trying to use the decode function on oracle within a but get an error any ideas?

[elmo_helper]

i have two tables one called table_customer and one called tbl_membership_type i have to use the decode function within a view to create to create a list showing customer_id, first_name, last_name, country, description. the view should include a column that lists the membership type Gold as AU, Silvr as Ag, and bronze as CuCn but the solution must not update or add any data in the original table.
i was thing it would be something along the lines of

CREATE view attempt1 as

SELECT tbl_customer.customer_id, first_name, last_name,country_of_residence, description_of_membership_type

DECODE ( description_of_membership_type, gold, 'Au'
silver, 'Ag'
bronze, 'CuSn')
FROM tbl_customer, tbl_membership_type

where tbl_membership_type.membership_type_code = tbl_customer.mebership_type_code

i am not sure if i have written the decode part correct and the join part im not sure if it should be some sort of left join.

the tables are as follows:

Table 1 - tbl_customer
customer id ----------------------------------------… PRIMARY KEY
last name
first name
date of birth
mebership type code ----------------------------------------… FOREIGN KEY
country of residence

table 2 - tbl membership type
membership type code ----------------------------------------… PRIMARY KEY
description of membership type
monthly fee uk pounds
download limit

I have also tried
CREATE view "attempt1" as

SELECT tbl_customer.customer_id, first_name, last_name,country_of_residence, tbl_membership_type.description_of_membe…

FROM tbl_customer RIGHT OUTER JOIN tbl_memership_type
on tbl_membership_type.membership_type_code = tbl_customer.membership_type_code

DECODE ( description_of_membership_type, gold, 'Au'
silver, 'Ag'
bronze, 'CuSn')

but get this error: ORA-00933: SQL command not properly ended

any help would b great have been struggling with this for days!

[stecal]

Add a ; at the end of your create table statement.

[LKBrwn_DBA]

-- Etc --
i am not sure if i have written the decode part correct and the join part im not sure if it should be some sort of left join.
-- Etc --

None of your views seems to have a valid syntax -- try again.

[gandolf989]

You can also use the case statement if you have Oracle 10g or higher. You should definitely use the inner join clause to join the tables. In my example NAM means not a member, you should always have an else to your case unless you verify that the value will always fall within the WHEN clauses.

CREATE view attempt1 as
   SELECT tbl_customer.customer_id, first_name, last_name,
          country_of_residence, description_of_membership_type,
          CASE description_of_membership_type
              WHEN 'gold'   THEN 'Au'
              WHEN 'silver' THEN 'Ag'
              WHEN 'bronze' THEN 'CuSn'
              ELSE 'NAM' description_of_membership_type
     FROM tbl_customer
    INNER JOIN tbl_membership_type
       ON tbl_membership_type.membership_type_code = 
          tbl_customer.mebership_type_code;