<p>HI,</p>

<p>I have 3 tables: <strong>Clips</strong>, <strong>Books</strong> and relationships between <strong>ClipBook</strong></p>

<p><strong>Problem is:</strong>
i need get <strong>book</strong> that has <strong>bookID=4</strong> with some clips i mean many-to-many</p>

<p>in simple text sql it will be something like this:</p>

<p><code>select * from Clips where clipID in (select clipID from ClipBook where bookID=4)</code></p>

<p><strong>Question is:</strong></p>

<p>How can i do this with <strong>Linq</strong> without operator <strong>Join</strong> of course</p>

I would use sed, like so:
```
```
for i in files
do
    sed -i 's/\t/    /' "$i"
done
```
```
That big block in there is four spaces. ;-)
I haven't tested that, but it
should
work.  And I'd back up your files just in case.  The -i flag means that it will do the replacements on the files in-place, but if it messes up, you'll want to be able to restore them.
This assumes that $files contains the filenames.  However, you can also use Adam's approach at grabbing the filenames, just use the sed command above without the "$i".