question

You have provided nothing more than a query. You need to provide some detail and what your actual question is.

Is this April the fool? Michael, I am starting to feel you are purposely trying to annoy the community!

Michael, thank you for making an attempt a solution this time (I added your comment to the original question so it could be formatted for easier reading). You are on the right track, but you need to tweak a few things.

First, when you are joining multiple tables that have a column in the same name, you need to disambiguate for the server. This can be done by prefacing the column name with either the table name or table alias. If you do not know what a table alias is yet, just use the table name, aliases will come later.

Next, when you are using a string literal, you need to enclose it in single quotes. Such as 'Internet Advertising'

Then, you cannot separate criteria in your where clause with commas, they have to be separate by 'and's. In your attempt you seem to go back and forth and use both.

The big problem of course is that I think you are answering the wrong question. You are specifying the skills it should be returning. If I understand the question right, that should be the results you get not the criteria you use.

If you want to try again and post another attempt here, I think many of us would be happy to comment on it. If including a code sample, please either post it as an answer or edit your original question. You cannot format code samples in a comment. Also, please remember to format the code samples. It is so much easier to read that way.

Select Skill_ID, Skill_Description 
From Skill,
Where Select_Id IN ( Select Skill_ID 
                     From Project_Skill
                            Where P_ID IN ( Select P_ID 
                                            From Project
                                            Where Project_ID = 'Internet Advertising'
                                           )
                    )

Brief Explanation: Above I use three queries; One main select query and two sub queries(or nested queries)

1. Lets start with the last one: What last sub query does is find the project ID of 'Internet Advertising' using the project table then it will pass the value to the middle query.
2. The middle sub query will return the value of the ID of the skills(Skill_ID) needed based on the project ID. Once it calculates the Skill_ID using the PROJECT_SKILL table it will pass the value to the first query
3. Now the first query has all the information and will use that to return the skill description along with the skill_id from the SKILL table.

Also you can solve these problem easily using JOINs.

I dont know if i helped or confused you here but you should be able to get the idea and research a little bit and you soon be able to solve the problem. Once again try a little bit harder to solve your homework by yourself before you post here.

Good Luck!!