Two questions:
1) Is there a place to get the Baan SQL Help topic? Our help is broken and I can't seem to find the SQL topic

2) I am looking to grab a contract ID from a table where the status is Live. The psuedo-sql (in my .qcd file) would be:

select tdpsc001.cont
from pdpsc001
where suno = :supp
and item = :thisItem
and stat = (select stat
from tcmcs070
where styp = :1).

Is this correct?

Thanks

Just follow the link on the top of the page that says "Wiki". Beware it is a Baan 5 manual, but is still very useful for Baan 4. Our help in Baan has been corrupt from Day 1.

Mark

http://www.baanboard.com/programmers_manual_baanerp_help_functions_database_handling_baan_sql

Thanks. I forgot about that guide!

You responded to quick. :) I added a link to the Baan SQL page into my other post.

Mark