importing multiple records into one record

[mcbradford]

I hope this can be done....

 

I want to import from a oracle db using sql.

 

SELECT T.TASK_ID, T.METHOD, T.SAMPLE_ID, S.MATERIAL_NAME, S.SAMPLE_ID, S.TIMESTAMP, T.CONDITION, T.STATUS, T.METHOD_DATAGROUP FROM OPS$PENLIMS1.NAI_TASKS T, OPS$PENLIMS1.NAI_SAMPLES S WHERE (S.SAMPLE_ID=T.SAMPLE_ID) AND (S.SAMPLE_ID='200383272') AND OPERATION >'0'

 

This will return 8 records.

 

I want 1 record, with all the task information.

 

For example - this will return all the task associated with one sample number. The problem is the task are each a record.

 

What I really want is a list of sample id's with the task id's listed - so 1 record for each sample containing the list of task.

 

I created a file that will list all the samples that are incomplete. I have another file that will list all the task for ONE sample.

 

I am thinking what if I send the string of incomplete samples into the sql? Thinking as I am typing????

 

Does this make any sense?

[mcbradford]

I think I've got it.

 

SELECT T.TASK_ID, T.METHOD, T.SAMPLE_ID, S.MATERIAL_NAME, S.SAMPLE_ID, S.TIMESTAMP, T.CONDITION, T.STATUS, T.METHOD_DATAGROUP FROM OPS$PENLIMS1.NAI_TASKS T, OPS$PENLIMS1.NAI_SAMPLES S WHERE (S.SAMPLE_ID=T.SAMPLE_ID) AND (S.SAMPLE_ID IN ('200383272', '200383273')) AND OPERATION >'0'

 

I can return all the records - use the portal relationship sample_id = sample_id.