Query databased Result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi I'm quite new in using Access but we need to use Access as a tools for
check Oracle database so I use ODBC. I successfully access the database and
get every table I want but when I create query and link these table together
not all data is being reflected in the query result. Note that when I used
quesry and add all Table.
MS access automatically link every table.

Hope you understand and can help me.

Regards
 
You need to set the Joins according to the relationship of the data from
Oracle server rather than relying on Access to guess the Joins. Access will
automatically link Fields with same name from different Tables, AFAIK.

You also need to decide whether the Joins should be Inner Join or Left Outer
Join or Right Outer Join according to the data and what you want the Query
to return.

Check Access Help on the different types of Joins above.
 
Dear Van,

Thank you for your help I already solve this.
I have another question, Does all Table can be joined together ?,
I have a problem in joining 2 table to get my desired data. I cannot link
them both
or get their key data field that can join them together

Regards,
 
In a Query, Tables don't have to be joined together.

For example, you can sinly put 2 Tables in a Query without any Join and in
this case, we say the Tables are unjoined or, (slightly more confusing but
logical), the 2 Tables are in a Cartesian or cross- Join. However, the
number of rows is the product of the numbers of Records in each Table, e.g.
if each Table has 1000 Records, the Query will return 1,000,000 rows.
 
Dear Van.

Thank you I aprreaciate your effort to explian it to me Thank you.
Apprently, When you Query two table with wihtout jointing you cannot
get the data that you want. I usually get the data in database of Oracle and
made an ODBC connection to Access. I used the key data per table to joing in
the key data to another Table but this Table dont have the same key data. Is
there another way to get the data from these table to another table?

Regrads,
 
I am not sure from your description what you are trying to do...

Perhaps, you should describe the details of the relevant Tables, how they
are related and what you want the Query to return.

Post a small sample of data and the the required return of the Query for the
posted sample.

Also, check Access Help on "Pass-Through Queries" which uses Oracle SQL.
Pass-Through Queries can be very efficient as the processing is actually
done by the Oracle database engine and only the selected data is returned to
the Access Front-End which reduces much of the data required to be
transferred if the selection is only a small part of the data from the
Oracle Tables.
 
Back
Top