SQL Problem, I think it has to do with joining tables... -> Nevefrmind..
ok.. I have this query that works perfect in SQL Plus.. But it does not work in my code.. I think it has to do with joining the tables.. I get this error:
Additional information: ORA-00904: "TEST_DATA"."SERIAL_NUMBER": invalid identifier
Here is my SQL statement:
select
count(test_data.serialnumber),
avg(test_data.test_param5),
stddev(test_data.test_param5),
min(test_data.test_param5),
max(test_data.test_param5)
from test_data , serial_master where
test_data.serialnumber = serial_master.serialnumber and
serial_master.model = 'XX'and
test_data.dept = 'T' and
test_data.pass_fail = 'PASS' and
test_data.test_param1 > 0 and
(test_data.sys_date >= '01-November-2004' and
test_data.sys_date <= '31-December-2004');
Re: SQL Problem, I think it has to do with joining tables...
Nevermind.. Stupid Typo... I saw it right after I posted this.. Figures.. I looked at it for about 1/2 hour first too... :eek2: :rolleyes: