March 30, 2009, 05:24 PM
Enigma006[CLOSED] SQL to Webfocus
Hai all,
I have a SQL query and I am working on its WF equivalent. The following code comes in where condition of the SQL query. Sample is like..
select * from tablename1
where condition1 and condition2
and (exists (select '1' from tablename2
where condition))
How to code the EXISTS part of the query?
Thanks all..
This message has been edited. Last edited by: Kerry, March 30, 2009, 09:39 PM
Jim MorrowIf you are qoing against a SQL data source just do a SQL pass throught.
If you are using a Focus data base (or other sourse) do a table to make a save file then use the "where in file"
You will find examples of both in the various FOCIS manuals.