Getting Total Records When Child Table Has a Value 1

[tekdudedude]

Hello,

In an Oracle 10g database I have two tables: documents and document_pages. The document_pages is a child table to the documents table. The document_pages table has a varchar2 type field where the values are either: 'HTML' or 'TEXT'.

What SQL can I use to get a count of how many document's contain 'HTML'?


Thanks,

TD

 

[jaxtell]

select count(docs.*) from documents docs, document_pages docpgs where docs.some_id = docpgs.some_id and docpgs.doc_type = 'HTML'

 

[PHV]

get a count of how many document's contain 'HTML'
SELECT COuNT(*)
FROM document_pages
WHERE type = 'HTML'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[r937]

get a count of how many documents contain 'HTML'
SELECT COUNT(DISTINCT doc_id)
FROM document_pages
WHERE type = 'HTML'



r937.com | rudy.ca

 

[tekdudedude]

All very good posts. Thanks all.

r937's was the ideal SQL for what I am doing.

Thanks again,

TD