TABLE FILE {Data source 1} PRINT FIELDs BY FIELDs {Filters} ON TABLE HOLD ... MORE FILE {Data source 2} {Filters} END
Prod: | WebFOCUS 7.6.10/8.1.04 | Upgrade: | WebFOCUS 8.2.07 | OS: | Linux | Outputs: | HTML, PDF, Excel, PPT |
In Focus since 1984 | |||||||
Pity the lost knowledge of an old programmer! |
quote:Originally posted by Waz:
You don't do it with a JOIN, but with TABLE FILE and the MORE command.
e.g.TABLE FILE {Data source 1} PRINT FIELDs BY FIELDs {Filters} ON TABLE HOLD ... MORE FILE {Data source 2} {Filters} END
This does rely on the two tables having the same columns specified by the first part of the request.
Any Filters are local to the individual data source.
quote:Could the "same columns" be DEFINE fields?
Prod: | WebFOCUS 7.6.10/8.1.04 | Upgrade: | WebFOCUS 8.2.07 | OS: | Linux | Outputs: | HTML, PDF, Excel, PPT |
In Focus since 1984 | |||||||
Pity the lost knowledge of an old programmer! |
quote:Originally posted by Waz:
[And jumps pack in his Delorean].....
Prod: | WebFOCUS 7.6.10/8.1.04 | Upgrade: | WebFOCUS 8.2.07 | OS: | Linux | Outputs: | HTML, PDF, Excel, PPT |
In Focus since 1984 | |||||||
Pity the lost knowledge of an old programmer! |