SQL Problem, I think it has to do with joining tables... -> Nevefrmind..

[RudyL]

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');

[RudyL]

Nevermind.. Stupid Typo... I saw it right after I posted this.. Figures.. I looked at it for about 1/2 hour first too...