SELECT Details window (VA Smalltalk database guide)

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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!

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To post to this group, send email to [hidden email].
To unsubscribe from this group, send email to [hidden email].
For more options, visit this group at http://groups.google.com/group/va-smalltalk?hl=en.

Thanks!

Narender
Reply | Threaded
Open this post in threaded view
|

Re: SELECT Details window (VA Smalltalk database guide)

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!

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To view this discussion on the web visit https://groups.google.com/d/msg/va-smalltalk/-/cPeaoS-OAEMJ.
To post to this group, send email to [hidden email].
To unsubscribe from this group, send email to [hidden email].
For more options, visit this group at http://groups.google.com/group/va-smalltalk?hl=en.
Thanks!

Narender
Reply | Threaded
Open this post in threaded view
|

Re: SELECT Details window (VA Smalltalk database guide)

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!

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To view this discussion on the web visit https://groups.google.com/d/msg/va-smalltalk/-/rc3XavNdQEUJ.
To post to this group, send email to [hidden email].
To unsubscribe from this group, send email to [hidden email].
For more options, visit this group at http://groups.google.com/group/va-smalltalk?hl=en.
Thanks!

Narender