From: luciosan <luciosan@...>
Date: 2007-10-10T23:20:11+09:00
Subject: HELP - From SQL to Ruby

Hi

How I can execute this query on Ruby?

SELECT *
FROM table_1 T
WHERE T.document_id not in (SELECT distinct documnet_id FROM
binary_files);

Now, I execute without proble the second part of query (SELECT
distinct documnet_id FROM binary_files) in this
method:BinaryFile.find(:first, :select => 'distinct document_id')

I've all crontrollers and all models

Thank you

-- 
I'm using an evaluation license of nemo since 48 days.
You should really try it!
http://www.malcom-mac.com/nemo