Re: Require help with Join syntax for resident tables
Where ADMIT_DATE >= START_DATE
And ADMIT_DATE <= STOP_DATE;
Drop Table TempTable;
After this lines, you will have three tables. The original Tables TableA and TableB, plus a new table, FinalTable, with only one field SINO, containing those SINO whose ADMIN_DATE is between START_DATE and STOP_DATE. All three tables linked by field SINO.