By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,679 Members | 2,469 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,679 IT Pros & Developers. It's quick & easy.

Join query not retrieving records

P: 9
hi

i had created two table

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
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 all the records in the enquiry table
which r not in the student table

Expand|Select|Wrap|Line Numbers
  1.  
  2. select a.student_id, a.student_name, b.gender, b.Qualification,
  3. b.course_id, a.staff_id, a.date_of_join, a.batch, b.address,
  4. b.city, b.phone_no, b.mobile, b.email_id, a.status
  5. from student a, enquiry b
  6. where a.enquiry_id=b.enquiry_id
  7.  
im trying to get the above query result in forms 6i

its not getting plz help.....
May 17 '07 #1
Share this Question
Share on Google+
3 Replies


P: 9
hi

i had created two table one is parent and another one is child

using this two tables i created two datablock in the same canvas
in forms 6i

when im running the form ,i'm getting the records in the child table
which r not in the parent table (i.e) join is not working

i clicked the mouse in the child table to see next records
after that i move the mouse to the parent table to see the next records
im geeting query caused no records to be retrived

select a.student_id,a.student_name,b.gender,b.Qualificati on,
b.course_id,a.staff_id,a.date_of_join,a.batch,b.ad dress,
b.city,b.phone_no,b.mobile,b.email_id,a.status
from student a,enquiry b
where a.enquiry_id=b.enquiry_id

I'm trying to get the above query results but i cant plz help me .....
May 17 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
hi

i had created two table one is parent and another one is child

using this two tables i created two datablock in the same canvas
in forms 6i

when im running the form ,i'm getting the records in the child table
which r not in the parent table (i.e) join is not working

i clicked the mouse in the child table to see next records
after that i move the mouse to the parent table to see the next records
im geeting query caused no records to be retrived

select a.student_id,a.student_name,b.gender,b.Qualificati on,
b.course_id,a.staff_id,a.date_of_join,a.batch,b.ad dress,
b.city,b.phone_no,b.mobile,b.email_id,a.status
from student a,enquiry b
where a.enquiry_id=b.enquiry_id

I'm trying to get the above query results but i cant plz help me .....
Check the datatypes of the enquiry_id fields in both the student and enquiry table. If they have a different datatype this may be the problem.
May 19 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Your two questions have been merged. Double posting in the forums is frowned on. If your question is not attended to in a reasonable period of time then post a reply to boost it up the list.

ADMIN
May 19 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.