could any one help me please to match multiple tables.i just implemented with two tables

This message has been edited. Last edited by: <Emily McAllister>,

Durai,

please.

This is basic functionality. Easily found in both the GUI and the "help"-option in the menu.

I posted this link on your other thread.

Just click here and see the magic: http://infocenter.informationb...ource%2Ftopic153.htm


Resume:

The syntax of a MATCH request is:

  
MATCH FILE filename    (the OLD file) report request 
BY field1 [AS sortfield]
MORE
FILE file3
subrequest 
RUN
.
.
.
FILE filename2         (the NEW file) report request 
BY field1 [AS sortfield1]
.
.
.
[AFTER MATCH HOLD [AS filename]  matchtype]
MORE
FILE file4
subrequest 
END

where:
matchtype
Can be any of the following:
OLD
NEW
OLD-NOT-NEW
NEW-NOT-OLD
OLD-AND-NEW
OLD-OR-NEW
OLD-NOR-NEW

This message has been edited. Last edited by: Ricardo Augusto,

Hi Durai,

Sounds like you might benefit from getting a copy of the WebFOCUS Keysheet. It has all the commands that are available in WebFOCUS and with the addendum goes through the current version. It is a quick way to see all those cool commands. Check it out at www.aviter.com.