I am new to WebFOCUS and not sure how it can use a self-contained subquery to pass a single value. Below is my sample code. Any help would be appreciated.


DEFINE FILE TableOne
CRDATE/YYMD = HDATE(CalendarDate, 'YYMD');
END

TABLE FILE TableOne
BY CalendarWeek
WHERE CalendarDay EQ &YYMD
ON TABLE HOLD AS CRWEEK

TABLE FILE TableTwo
SUM Price
BY Category
WHERE CalendarWeek EQ CRWEEK.CalendarWeek

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

WHERE CalendarWeek IN FILE CRWEEK;

Wep probably has guessed it right, but I find your code confusing. Your DEFINE creates a new filed called CRDATE that you don't explicitly reference in your table, so I'm wondering why you included the DEFINE in your example.

In your first TABLE you don't have a VERB or OBJECTS so it's tough to figure out what the intention is - what you will get are some values that have CalendarDay equal to today.

The second TABLE references CalendarWeek. Is this a database field?

Finally, since the first TABLE will just give you back today's date, why not just plug in &YYMD in the second table?