whats wrong with this query?

[ballhogjoni]

SELECT c.id ,sum(cs.sale_count) - sum(cs.nosale_count) as sales

FROM travel_companies c,travel_company_sales cs

WHERE approved = 1 AND deleted = 0 AND c.id IN (3575,182,15,701,4550)

AND (c.name LIKE '%sport%' OR c.code LIKE '%sport%') ORDER BY cs.sales asc LIMIT 0,5;

 

I get an error saying that cs.sales is unknown column

[flyhoney]

FROM travel_companies as c,travel_company_sales as cs

[ballhogjoni]

FYI: the AS does not matter, thx tho

[Mark Baker]

I get an error saying that cs.sales is unknown column

Is there a column called sales in the travel_company_sales table,

or are you trying to sort on the result of sum(cs.sale_count) - sum(cs.nosale_count)?

[ballhogjoni]

trying to sort on the result of sum(cs.sale_count) - sum(cs.nosale_count)?

 

This...I figured it out. I took off the cs. which makes sense!

[Maq]

Maybe it's conflicting between

 

as sales

 

and then trying to access cs.sales  ???

[premiso]

SELECT c.id ,(sum(cs.sale_count) - sum(cs.nosale_count)) as sum_sales
FROM travel_companies c,travel_company_sales cs
WHERE approved = 1 AND deleted = 0 AND c.id IN (3575,182,15,701,4550)
AND (c.name LIKE '%sport%' OR c.code LIKE '%sport%') ORDER BY sum_sales asc LIMIT 0,5;

 

Should produce the desired result, note the change of the column to sum_sales.

 

Since you have a column called sales in another table, that is the best way to do it to make sure you know what you are calling.