473,320 Members | 1,867 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Join query not retrieving records

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
3 1517
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
14,534 Expert Mod 8TB
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
14,534 Expert Mod 8TB
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

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

Similar topics

4
by: Omavlana | last post by:
Hi, I need your help to resolve this problem. I have written a right outer join query between 2 indipendent tables as follows. select b.Account_desc, b.Account, a.CSPL_CSPL from...
5
by: Randy Harris | last post by:
Using an outer join, a query can return all records from Table1 and only those matching from Table2 (or vice versa). How can I write a query that will return unmatched records from both sides? ...
4
by: Shahzad | last post by:
dear respected gurus, I would like to knew how to apply append,insert query for a self table where no primary keys issues. i do have problem say there are 5 rows of single record, this is data...
4
by: bhargav.desai | last post by:
Hello Gurus, I need help! I have two table, tblCurrent and tblPrevious. What I want to join the tables, and create a new table that have matching records from both the tables, plus this new...
52
by: MP | last post by:
Hi trying to begin to learn database using vb6, ado/adox, mdb format, sql (not using access...just mdb format via ado) i need to group the values of multiple fields - get their possible...
1
by: Preeti.s83 | last post by:
is it possible to replace join type ( for eg. nested loop with hash join and so on) in xml plan... we will fst take plan in xml format ( show xml plan ) and then we will replace join with other...
5
by: Bob Bridges | last post by:
Start with two tables, parent records in one and child records in the other, a one-to-many relationship. Create a select statement joining the two. Display the query in datasheet mode. When I...
3
by: Zeff | last post by:
Hi all, I have a relational database, where all info is kept in separate tables and just the id's from those tables are stored in one central table (tblMaster)... I want to perform a query, so...
1
by: Nettle | last post by:
Purpose: This is a Distribution List database. Function: Users create many different email distribution lists, tailoring each to fit their specific needs Wanted: Users can combine...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.