SQL JOIN Query

[Silvinho]

I have a table with uploaded files such as images in it.

I have another table that has an ntext field with content in it which may or may not include some of the image files.

What i want to do is create a query that lists all the uploaded files and counts how many times each file is used within the content table.

Is this possible, ive tried everything but im getting nowhere?

 

[eselhassan]

I suggest you write some code and let us know what you'r thinking and I'm sure someone will help you.