how to l join theses tabless

[professor123]

can l plz ask you something ... l hav a database with 4 tables i.e

User(fname, lname,email and userid ------primary key{userid} )

Exam( examid, examname-------primary Key{userid})

Exam_user(examid, userid------primary key{examid})

Exam_category(categoryid, categoryname----prmary key{categoryid})

HOW CAN YOU WRITE AN SQL QUERY THAT ALLOWS U TO CREATE/retrieve A NEW
TABLE WITH FIELDS;;;;

(fname, lname,email, userid,examid, examname,categoryname)

[smantscheff]

To retrieve the values, use a SELECT query.
Study the JOIN syntax (http://dev.mysql.com/doc/refman/5.1/en/join.html) and give it at least a try before you ask for help. Come back when you cannot work it out.
To create a table with those values, use the CREATE TABLE AS SELECT ... syntax (http://dev.mysql.com/doc/refman/5.1/en/create-table.html)

[jlego]

CREATE TABLE new_table as
SELECT this, that, this, that FROM old_table