consulta de un solo registro
Publicado por iliana (5 intervenciones) el 15/11/2006 17:55:06
hola tengo este query
select u.HRORACLENUMBER as hrnum, u.lastname || ' ' || u.firstname as name,
v.VOUCHERDATE as voucherdate, v.USEDHOURS as usedhours,
REPLACE(REPLACE(v.DESCRIPTION, CHR(13), ' '),CHR(10), ' ') as description,
p.PROJECT as project, a.CATALOGNAME as area FROM
general.vouchers v, general.users u, general.projects p, general.areas a
WHERE
v.USERID = u.USERID
AND v.PROJECTID = p.PROJECTID
AND v.AREAID = a.CATALOGID
AND p.AREAID = a.CATALOGID
and v.voucherdate between '03-nov-2003' and '16-nov-2003'
ORDER BY
v.AREAID, u.HRORACLENUMBER, v.VOUCHERDATE
que instruccion puedo usar para que me muestre solo los que tienen un solo registro y no varios registros
select u.HRORACLENUMBER as hrnum, u.lastname || ' ' || u.firstname as name,
v.VOUCHERDATE as voucherdate, v.USEDHOURS as usedhours,
REPLACE(REPLACE(v.DESCRIPTION, CHR(13), ' '),CHR(10), ' ') as description,
p.PROJECT as project, a.CATALOGNAME as area FROM
general.vouchers v, general.users u, general.projects p, general.areas a
WHERE
v.USERID = u.USERID
AND v.PROJECTID = p.PROJECTID
AND v.AREAID = a.CATALOGID
AND p.AREAID = a.CATALOGID
and v.voucherdate between '03-nov-2003' and '16-nov-2003'
ORDER BY
v.AREAID, u.HRORACLENUMBER, v.VOUCHERDATE
que instruccion puedo usar para que me muestre solo los que tienen un solo registro y no varios registros
Valora esta pregunta
0