Posted by: बैरे August 13, 2009
I just need a Query!! For SQL janne Maanche!! VERY IMP
Login in to Rate this Post:     0       ?        

Here this is what I have created and this should yield the right result


 


SQL> desc User_Info
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FIRST_NAME                                NOT NULL VARCHAR2(30)
 LAST_NAME                                 NOT NULL VARCHAR2(30)
 ADDRESS                                   NOT NULL VARCHAR2(100)
 USER_NAME                                 NOT NULL VARCHAR2(20)
 PASSWORD                                  NOT NULL VARCHAR2(20)


SQL> desc Admission_Code
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 CODE                                      NOT NULL NUMBER(38)
 STATUS                                    NOT NULL VARCHAR2(20)


SQL> desc Univ_Code
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 CODE                                      NOT NULL NUMBER(38)
 UNIVERSITY                                NOT NULL VARCHAR2(30)


SQL> desc User_Admission_Status
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 USER_NAME                                 NOT NULL VARCHAR2(20)
 UNIV_CODE                                          NUMBER(38)
 ADMISSION_CODE                                     NUMBER(38)


SQL> select a.First_Name, a.Last_Name, a.Address, a.User_Name, b.Status, c.University from User_Info a, Admission_Code b, Univ_Code c, User_Admission_Status d where a.User_Name=d.User_Name and b.Code=d.Admission_Code and c.Code=d.Univ_Code;


no rows selected


Good Luck

Read Full Discussion Thread for this article