oracle - SQL Queries "00904. 00000 - "%s: invalid identifier" -

hi have following code

select  entertainer_id,         entertainer_groupname    casestudy_entertainer inner join casestudy_availability on  casestudy_entertainer.entertainer_id       = casestudy_availability.availability_entertainerid inner join casestudy_calendardates on  casestudy_availability.availibility_calendardateid       =  casestudy_calendardates.calendar_id   entertainer_type = '&entertainer_type'  ,     casestudy_calendardates.calendar_date = '&event_date' 

and don't seem able figure out not liking when run this. gives me following error

ora-00904: "casestudy_availibility"."availibility_calendardateid": invalid identifier 00904. 00000 - "%s: invalid identifier" *cause:
*action: error @ line: 7 column: 4

i have tables in place correct rows. thing have no data of yet, possibly issue?

you should try lower case table/column identifiers(like in from/inner join clauses):

select  entertainer_id,         entertainer_groupname    casestudy_entertainer inner join casestudy_availability on casestudy_entertainer.entertainer_id = casestudy_availability.availability_entertainerid inner join casestudy_calendardates on casestudy_availability.availibility_calendardateid = casestudy_calendardates.calendar_id entertainer_type = '&entertainer_type'   , casestudy_calendardates.calendar_date = '&event_date'