Can such a SQL clause as the line with the "****" next to it (below) be written using a Criteria object? Thanks.
SELECT distinct rau.dodaac_code, ro.org_code || ro.org_type || ro.org_kind unit_id, **** ro.org_name, ra.telephone, rau.process_name FROM ref_org ro, ref_dodaac rd, ref_address ra, ref_address_usage rau WHERE ro.dodaac_code = rd.dodaac_code and ro.dodaac_code = rau.dodaac_code and ro.org_code = rau.org_code and ro.org_type = rau.org_type and ro.org_kind = rau.org_kind and rau.address_id = ra.address_id ORDER BY rau.dodaac_code --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
