OK, I openly admit I am not an Oracle person - I am having some trouble with getting my head used to the syntax differences, etc. -- I have a Crystal report that is using this data (with a subreport) and it pulls in EXACTLY what I need, but I need to get rid of the subreport (long story) and cant seem to get the view in Oracle to behave.
I have a table that shows unique workorder_no's. This table is HUGE and I have a select statement that works perfectly for this part. I have a second table workorder_def, which has multiple records for each workorder_no.
For example:
12345 This is line item description one and
12345 the table brings in multiple lines for ea
12345 ch work order. I need only one line, the very
12345 top one, (first record entered) for the
12345 work order number.
I have one field in this table called row_added_ts, which is a timestamp of the entry. I am trying to do a select statement taht will give me one entry for each work order, and it should be the one with the earliest timestamp on it.
Its simple to do in Crystal, real easy in SQL, and yet I cant get it to behave in Oracle. I think something's different with the way it handles DISTINCT?
I've been wrestling the darn thing for 2 full days now, and would truly appreciate any and all help!!
LMC
cryerlisa@hotmail.com
cryerwest@myaetherbb.com
LMC cryerlisa@hotmail.com
select * from Management where proj_mgmt_skills <> NULL
0 records returned
I have a table that shows unique workorder_no's. This table is HUGE and I have a select statement that works perfectly for this part. I have a second table workorder_def, which has multiple records for each workorder_no.
For example:
12345 This is line item description one and
12345 the table brings in multiple lines for ea
12345 ch work order. I need only one line, the very
12345 top one, (first record entered) for the
12345 work order number.
I have one field in this table called row_added_ts, which is a timestamp of the entry. I am trying to do a select statement taht will give me one entry for each work order, and it should be the one with the earliest timestamp on it.
Its simple to do in Crystal, real easy in SQL, and yet I cant get it to behave in Oracle. I think something's different with the way it handles DISTINCT?
I've been wrestling the darn thing for 2 full days now, and would truly appreciate any and all help!!
LMC
cryerlisa@hotmail.com
cryerwest@myaetherbb.com
LMC cryerlisa@hotmail.com
select * from Management where proj_mgmt_skills <> NULL
0 records returned