Hi, I presume nested statements are also not supported in the end-user facility? Sorry, just getting into some more difficult SQL statements and just trying to ascertain the do's and dont's
You can nest a select statement inside of a search criteria value edit box if that is what you mean. There is no visual tool for nested queries. You can perform joins, but you can't add a criteria as part of the join statement. These are on the to-do list of features.
Comments
if that is what you mean. There is no visual tool for nested queries. You
can perform joins, but you can't add a criteria as part of the join
statement. These are on the to-do list of features.
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com
Alex