db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tim Clotworthy" <tclotwor...@bka-inc.com>
Subject OR-ing of select criteria
Date Fri, 11 Jul 2003 18:33:14 GMT
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message