Mysql query is not working

Rails
1

Please,

Can anyone help me to execute this query?

SELECT * FROM table WHERE customer_id IN (SELECT IF(1 <> 2,‘SELECT
customer_id FROM customers’,‘SELECT customer_id FROM company’))

Regards…

2

On May 14, 2009, at 5:34 AM, Venkat E. wrote:

Please,

Can anyone help me to execute this query?

SELECT * FROM table WHERE customer_id IN (SELECT IF(1 <> 2,‘SELECT
customer_id FROM customers’,‘SELECT customer_id FROM company’))

Regards…

No!

It looks like you’re trying to do either:

SELECT table.* FROM table INNER JOIN customers ON
customers.customer_id = table.customer_id

or:

SELECT table.* FROM table INNER JOIN company ON company.customer_id =
table.customer_id

So you can do either of those (after you substitute for ‘table’ of
course)

If this is Rails (ActiveRecord), then ask your question again with
some more background and perhaps a bit of code (not SQL) and you’ll
get a better answer. (And that answer will probably show you how to
use has_many and belongs_to associations in your models.)

-Rob

Rob B. http://agileconsultingllc.com
[email protected]

3

Rob B. wrote:

On May 14, 2009, at 5:34 AM, Venkat E. wrote:

Please,

Can anyone help me to execute this query?

SELECT * FROM table WHERE customer_id IN (SELECT IF(1 <> 2,‘SELECT
customer_id FROM customers’,‘SELECT customer_id FROM company’))

Regards…

No!

It looks like you’re trying to do either:

SELECT table.* FROM table INNER JOIN customers ON
customers.customer_id = table.customer_id

or:

SELECT table.* FROM table INNER JOIN company ON company.customer_id =
table.customer_id

So you can do either of those (after you substitute for ‘table’ of
course)

If this is Rails (ActiveRecord), then ask your question again with
some more background and perhaps a bit of code (not SQL) and you’ll
get a better answer. (And that answer will probably show you how to
use has_many and belongs_to associations in your models.)

-Rob

Rob B. http://agileconsultingllc.com
[email protected]

Thanks… Rob B.

I got the solution for that…below code is working fine for me… :slight_smile:

SELECT * FROM books WHERE customer_id IN (SELECT customer_id FROM
customers WHERE (IF(‘#{user_type}’ <> 2,customer_id IS NOT
NULL,company_id=‘“cus01”’)))

4

Venkat E. wrote:
[…]

Thanks… Rob B.

I got the solution for that…below code is working fine for me… :slight_smile:

You completely missed Rob’s point. If you’re using Rails, then in most
cases you should be letting ActiveRecord write the SQL, not writing SQL
yourself!

SELECT * FROM books WHERE customer_id IN (SELECT customer_id FROM
customers WHERE (IF(‘#{user_type}’ <> 2,customer_id IS NOT
NULL,company_id=‘“cus01”’)))

This is a waste of time (and the syntax is wrong). What you want is
probably something like

if user_type == 2
books = Customer.find_all_by_company_id(‘cus01’).books
else
books = Customer.find(:all, :conditions => ‘company_id is not
null’).books
end

See? Much cleaner. If you’re going to use Rails, take the time to
learn how to work with it, not against it.

Best,

Marnen Laibow-Koser
http://www.marnen.org
[email protected]