Help me with this SQL question

Lets see the query you are working on, to solve your assignment.

that is a question from a past paper.What did you mean by seeing a query i am working on?the answers for (a) and (b) questions?I have done them but I even don't understand those above questions ?

which part you do not understand ? creating view ?

To display the following out put.It has two tables!
(d) create a database vies thing to.what is a view and isn't that what they have already done in the previous question?(see the pic http://oi52.tinypic.com/2ztix5l.jpg

If you are already getting the desired output using your SQL by joining both the tables, simply create a view based on that SQL. Once the view is created no need to write your SQL again and again. You can directly select from the view.

join?how to join tables?Can't i just type
Select field1,field2,field3
from table1,table2
and get the combined output? that is what i thought but didn't work

Your tables should be joined like this

SELECT st.studname, su.subjectname, st.marks FROM 
student st, subject su
WHERE st.subjectcode = su.subjectcode

Is this the SQL query?
how did st. came in front of the studname?can we change them just like that?

what about something like this

SELECT studName, subjectName, marks
FROM Student
JOIN Subject
ON Subject.subjectCode = Student.subjectCode
ORDER BY studName
???? help

st. ---- used in query is the table alias. It is a fully qualified name of the field.

Ok, tell me how will you display subjectcode after joining both the tables.

From those answers what is the correct one?your or mine?For what question then?these questions are strange

Ok, tell me how will you display subjectcode after joining both the tables.

I dont know anything about displaying rather than inserting,creating....... :O .and lil bit of joining

That is a question from my side to you.

I don't you.aren't you supposed to give answers for mine rather than ASKING from me ? :p

You are right . :)

But to understand my answers, you need to have some basic understanding of SQL.

My question is just to test that.

My question is still open to you. The sooner you reply, the sooner you will get reply :) .

I don't know even about that :/

If you do not understand my answers why should i reply, what is the use ?

because ,I can see your answer and then refer to the tutorials about each part i can't understand ?or you can refer me to some links (or names of the topics,i will find the tutes)which will help me to answer both of above answers after reading them?both are helpful

Ok, to answer your question, you can use either of the queries. Both will give you correct data in the output.

you mean for the database view question or the query question ?under what topic should i be looking for tutorials about them ?

You can create a view like this

CREATE VIEW stu_sub AS SELECT st.studname, su.subjectname, st.marks FROM
    student st, subject su
    WHERE st.subjectcode = su.subjectcode

OR using your SQL and use that.

ok.thanks.what about the query question then?

You can use either of the queries.

but what is the most accurate type?

Both query will fetch same output.

It is up to you to decide whether to use coding standards or not.

If you want that take my SQL else pick yours.

k.I thought my SQL is wring .it was guessing kinda thing

if you had replied to my question, you would have known the difference between the two.

hmm....k.thanks for the help btw