Re: Combine two tables
... AS b USING( Left(DateTime,10) );
... or an approximating join ...
On b.DateTime BETWEEN a.DateTime - INTERVAL 3 SECOND AND A.DateTime + IMNTERVAL 3 SECOND;
... or upgrade your DDL to have each table carry a matching ID for queries like this.
Edited 1 time(s). Last edit at 10/20/2021 09:54AM by Peter Brawley.
Subject
Written By
Posted
Re: Combine two tables
October 20, 2021 09:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.