Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.33 » View Incident Report |
Serious |
Reported By: Eric Hargreaves [E.M.A. Computer Solutio Reported On: 7/5/2012 For: Version 4.32 Build 1 |
Create two tables first called jobs with three columns, one string column called anything you like and two date columns JB_DueInDate and JB_DueOutDate. The second table called WorkDays with two columns WK_Type string size 1 and wk_day type date. Put some data in and run the following query in standard database system utility program. select * from Jobs left outer join WorkDays on ((WK_Type = 'D') and (WK_Day between JB_DueInDate and JB_DueOutDate))
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |