quick SQL help please

[Amanda Leigh]

I am getting the error "Identifier or Quoted Identifier Expected" when i try to execute this in my code, however it works fine in SQL Plus or SQL Worksheet. What am I missing?

SELECT DISTINCT
matrix_list.sample_type
FROM 
  (SELECT DISTINCT s1.sample_type
   FROM lims_sys.sample_user su1,
        lims_sys.sample s1,
        lims_sys.sdg_user sdgu1
   WHERE sdgu1.SDG_ID = s1.SDG_ID AND
        s1.sample_id = su1.sample_id and
        s1.status <> 'X' AND
        s1.sample_type <> 'Solvent' AND
        ((su1.u_qc_sample_type is null AND s1.name NOT LIKE '%IDL%') OR 
        (su1.u_qc_sample_type = 'MB' AND 
        su1.u_associated_matrix is null))   
        and sdgu1.u_sample_set_id in ('835')) matrix_list

[edited to add code tags]
[ December 12, 2004: Message edited by: Jeanne Boyarsky ]

[Jim Cheng]

You need to handle special characters properly in Java like single/double quotes.

Could you post the java code which actually embed the SQL statement?

Jim

[Stefan Wagner]

Have you ever thought about indentation?

SELECT
DISTINCT matrix_list.sample_type
FROM
(
SELECT DISTINCT s1.sample_type
FROM
lims_sys.sample_user su1,
lims_sys.sample s1,
lims_sys.sdg_user sdgu1
WHEREsdgu1.SDG_ID = s1.SDG_ID
ANDs1.sample_id = su1.sample_id
ands1.status <> 'X'
ANDs1.sample_type <> 'Solvent'
AND(
(su1.u_qc_sample_type is null AND s1.name NOT LIKE '%IDL%')
OR(su1.u_qc_sample_type = 'MB'
ANDsu1.u_associated_matrix is null)
)
and sdgu1.u_sample_set_id in ('835')
) matrix_list

I never saw that syntax before:

SELECT a
FROM (
SELECT b
FROM c
) d

but I'm not an SQL-Expert, nor do I know every RDBMS.
[ December 11, 2004: Message edited by: Stefan Wagner ]

[Jeanne Boyarsky]

I added the code tags as suggested by Stephen. (The indentation was already there.)

Amanda, for the future, code tags are one of the UBB buttons directly below the edit window.