| Join is not working [message #238479] |
Fri, 18 May 2007 05:22  |
jeevanaganathan
Messages: 8
Registered: May 2007
Location: india
|
Junior Member |
|
|
hi
i had created two table enquiry and student,
enquiry table contains the information about the students who are enquiring about the course,student table contains information about student who all are joined in the institute
1. Enquiry table
ENQUIRY_ID (PK)
ENQUIRY_NAME
GENDER
ENQUIRY_DATE
QUALIFICATION
PHONE
ADDRESS
CITY
PINCODE
EMAIL_ID
COURSE_ID
PURPOSE
DESCRIPTION
STATUS
2.Student table
ENQUIRY_ID (FK)
STUDENT_ID
STUDENT_NAME STAFF_ID
DATE_OF_JOIN
BATCH
STATUS
Using this two table i had created two data block in form 6i
My canvas look like this:
STUDENT_ID GENDER
STUDENT_NAME QUALIFICATION
STAFF_ID PHONE
DATE_OF_JOIN ADDRESS
BATCH CITY
STATUS PINCODE
FEES EMAIL_ID
COURSE_ID
STAFF_ID
when i running the form,it displaying the records in the enquiry table who are not joined in the course
which are not in the student table.
GENDER
QUALIFICATION
PHONE
ADDRESS
CITY
PINCODE
EMAIL_ID
It displaying the above fields which are in the enquiry table
Code: ( oracle8 )
SELECT a.student_id, a.student_name, b.gender, b.Qualification,
b.course_id, a.staff_id, a.date_of_join, a.batch, b.address,
b.city, b.phone_no, b.mobile, b.email_id, a.status
FROM student a, enquiry b
WHERE a.enquiry_id=b.enquiry_id
im trying to get the above query result in forms 6i
its not getting please help.....
[Updated on: Fri, 18 May 2007 05:27] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
