I have two master files in SQL Server 2005. Is there any way I could join them in FOCUS format and print data in report.
Thanks..This message has been edited. Last edited by: Kerry,
8.1.05 HTML,PDF,EXL2K, Active, All
March 05, 2009, 04:44 AM
GamP
Why ever would you want to join them in focus format? Just use the join command to join the tables and report off that sql 2005 structure.
GamP
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
March 05, 2009, 10:20 AM
PBrightwell
What GamP is telling you is that you can join any field in file one to any indexed field in the same format in file two with just: JOIN FIELD1 IN FILE1 TO FIELD2 IN FILE2 AS J1
Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes