Re: . Re: Has anyone ever created an Index Table that included a Join

Hi Tim


Thanks for replying. I was not sure about terms - there is no such thing as an index table on the i - I did look it up, and there seems to be something by that name, but it's nothing on this system.


JOIN and TABLE and INDEX are SQL things, and the i follows standards on those. Others have given you good information, I think. An INDEX is an actual file object of sorts, it's kind of a list of key values and the record or records those value point to. A VIEW is another kind of file object, but it merely contains an SQL SELECT statement in its description, and that statement is run when you open a VIEW. These cannot have ORDER BYs. VIEWs are where you can specify JOINs - they are just part of SELECT statements, and almost everything in a SELECT can be in a VIEW.


You can JOIN views and tables - if you want indexes that will support the JOIN criteria and any ORDER BY that you specify in the SELECT with the JOINs.


TMI? I suppose it might be. Someone asked what your end result is - what data do you want to work with, what problem are you trying to solve - that'd be interesting to tackle, perhaps.


Regards
Vern


On Thu, 2 May, 2024 at 8:58 AM, Timothy Feldmeier <Timothy.Feldmeier@xxxxxxxx> wrote:


To: midrange-l@xxxxxxxxxxxxxxxxxx

I simply wanted to create an Index over a table, and add a Join to another table. I wanted to know if anyone has done this before.

The information transmitted is intended only for the person or entity to which it is addressed and may contain proprietary, business-confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer.