Thread: SQL Help.. :)
View Single Post
Old 09-26-2005, 11:41 AM   #6 (permalink)
jdjammer
Tilted
 
Location: Paradise
If anyone was interested... this is the solution. I got it wrong.
COL WO# FORMAT 999
COL LAB_RATE FORMAT $90.00
COL JOB# FORMAT 9
COL LAB_HRS FORMAT 0.00
COL LAB_CHARGE FORMAT $999.00
COL "APPROVE?" FORMAT A8

SELECT A.WO#, A.WO_DATE, A.EFF_DATE, LABOR_RATE LAB_RATE
FROM
(SELECT WO#, WO_DATE, MAX(EFFECTIVE_DATE) EFF_DATE
FROM LABOR_RATE, WORK_ORDER
WHERE WO_DATE >= EFFECTIVE_DATE
GROUP BY WO#, WO_DATE) A
LEFT OUTER JOIN
(SELECT EFFECTIVE_DATE, LABOR_RATE
FROM LABOR_RATE) B
ON (A.EFF_DATE = B.EFFECTIVE_DATE)
ORDER BY WO# ;
jdjammer is offline  
 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73