SQLTeam.com | Weblogs | Forums

SQL Querry

I wanted to write a query but having difficulties doing so I was wondering if anyone can help me please? The question put forward to me is this, "How many documents have been created but not attached to the Curriculum?" I want to write this in a sql statement.

what have you done so far and this is homework?

1 Like

hope this helps :slight_smile: :slight_smile:

select count(*) from table
where curriculum <> 'Attached'
and created = 'Yes'

**"How many documents have been created but not attached to the Curriculum?** "
maps to different things in T-SQL
tables columns ... where conditons etc etc

Maybe something like:

select count(*) from Documents
where DocumentID not in (select DocumentID from Curriculum)
1 Like

thank you very much

thank you

1 Like