SELECT Details window (VA Smalltalk database guide)

[Narender Sharma]

Hi,
Can I create SQL queries that can join tables via VAST ? I cannot
see JOIN clause in the CLAUSE menu...

Thanks!

[Narender Sharma]

Its not that I have not created such query in smalltalk till now, but just wanted to know the right way to do it. Could not locate it in the documentation.

Thanks!

[Narender Sharma]

OK, so I can create JOINS from "manual queries" from Page 2 of query spec of the multi-row query.

But, is there a value add to creating queries this way VS writing the query as text, since any way it is a dynamic query(vis a vis performance, etc...)... Thoughts ? Suggestions...

Thanks!