I keep hearing mixed comments.

Can you Join Focus tables to Oracle tables ( as long as you have a common field?)

I've done it and haven't had problems but some programmers told me you may receive unpredictable results.

Thanks,
Jim

You can join them but you got understand that the reporting server does what you call NON-APT. It reads both the tables and does a FOCUS managed join. This will slow down the report.

Hi Jim,

I ran a search on "Oracle join with FOCUS database" and came across the following topics which may be of interest:

How to efficiently JOIN two extract files from Oracle?
http://techsupport.informationbuilders.com/sps/92661059.html

Oracle:extract data from a Multipath MFD
http://techsupport.informationbuilders.com/sps/92961068.html

JOIN with two Oracle tables run for a long time
http://techsupport.informationbuilders.com/sps/62531040.html

Summary: Oracle Cluster Join with WHERE limitation?
http://techsupport.informationbuilders.com/known_problems/83441024.html

Summary: JOIN FOCUS to ORACLE table does not bring back data http://techsupport.informationbuilders.com/known_problems/71151038.html

You will need to have a userid/password to access these documents.

Hope these help.

Cheers,

Kerry