×
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.
Thanks Alan.
I was thinking along those lines as well.
Rob was thinking too literally as I qualified that I was looking for concept.
Regards,
Richard Schoen
Web:
http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
------------------------------
message: 3
date: Fri, 12 Mar 2021 12:57:54 +0000
from: Alan Shore via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
subject: RE: Speaking of SQL.....
Try this
With tablefi as
(Select * from table1 join table 2 on date and type=?FI?),
tableI as
(Select * from table1 join table 2 on type=?I?)
Select a.* from tablefi a
Union all
Select b.* from tablei
Or something like that
Alan Shore
Solutions Architect
IT Supply Chain Execution
[cid:image001.png@01D71715.6745F8F0]
60 Orville Drive
Bohemia, NY 11716
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
E-mail : ASHORE@xxxxxxxxxxxxxxxxxxxx
midrange.com
