×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Top of my head - You can create a view over multiple tables - but not an
index.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Alan
Cassidy
Sent: Saturday, April 1, 2023 4:44 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: In SQL, can you create an index with JOIN's?
I seem to remember that you can only create indexes over one table, but I
have a vague memory of JOIN tables being introduced.
Or did I see something in a different implementation with something like
that?
I can't find the answer to that in the docs.
--Alan Cassidy
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
midrange.com
