[SOLVED] Joining a table to an archived copy of itself

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6617029966

March 31, 2014, 03:19 PM

Josh K

[SOLVED] Joining a table to an archived copy of itself

Say I have a report that creates a webfocus archive table. Its pulling from F4211 and several other tables and storing this with "ON TABLE HOLD AS XSOPBLOG FORMAT FOCUS INDEX..."

I have another report reading XSOPBLOG as the main input table. The problem is now I need a field SDOORN from F4211 but it was not stored in XSOPBLOG. I don't think I can change the report that is creating XSOPBLOG.

Can I join XSOPBLOG to F4211 based on a key? Or will that be impossible since the field names are the same?

This message has been edited. Last edited by: <Kathryn Henning>,