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)

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.