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 -
-
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 plz help.....
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 .....
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.
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
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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? ...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
| |