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?
hope this helps
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)
thank you very much