Home » Developer & Programmer » Forms » Join is not working
Join is not working [message #238479] Fri, 18 May 2007 05:22 Go to next message
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

Re: Join is not working [message #238962 is a reply to message #238479] Mon, 21 May 2007 01:28 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
How can an 'enquiry' have 'gender'? The 'student' has 'gender'. Why not have all this data in a single table? Use a 'view'.

David

[Updated on: Mon, 21 May 2007 01:28]

Report message to a moderator

Previous Topic: how can v create canvas using query
Next Topic: how to highlight ?
Goto Forum:
  


Current Time: Sun Dec 04 16:42:59 CST 2016

Total time taken to generate the page: 0.10163 seconds