Mercea Paul <paul.mercea@...> wrote: Hi,
/*************
I think best approach is to redesign the database adding new fieldTRUE (0,1)
to thet table (BusinessCl_3) and select like…
Select * from table where exists (select 1 from t2 where table.id=t2.id and
t2.fieldTRUE=1)

****************/
The database here is designed, created, maintained and accessed by the O-R mapper, in this case BOLD.
The original statement would appear to be dynamically built SQL to load some data. This group can help build better SQL, if it is possible to bypass/replace the BOLD SQL in the first place. That is a question for the BOLD/ECO support group. Return here, if that is achievable.
regards
WB




Recent Activity

7
New Members

Visit Your Group
Biz Resources
Y! Small Business
Articles, tools,
forms, and more.

Search Ads
Get new customers.
List your web site
in Yahoo! Search.

Yahoo! Groups
Discover healthy
living groups and
live a full life.



.





[Non-text portions of this message have been removed]