SQL problem (left join related most likely) - Webmaster Forum - Web Design, Programming and SEO forums

01-01-2008, 10:01 PM

Village Genius

Status: Geek
Join date: Apr 2006
Location: Denver, CO
Expertise: Software
Software: Chrome, Notepad++

Posts: 6,894

iTrader: 18 / 100%

Village Genius will become famous soon enough

SQL problem (left join related most likely)

I am making a polling script, I have it able to get the top 3 items voted for. I am trying to left join the item data with the result data with this query

Code:

SELECT `votes.poll_id` AS `votes_pollid`,
COUNT(`item_id`) AS `count`,
`item_id`,
`items.*` 
FROM `votes` 
LEFT JOIN `items` ON `votes.id`=`items.poll_id` 
WHERE `votes.poll_id` = '1'  
GROUP BY `item_id` 
ORDER BY `count` DESC 
LIMIT 3;

It tels me that votes.poll_id doesn't exist. That is simply not true, I can call votes.poll_id in a separate query and it comes up.

01-17-2008, 09:27 PM

.deMoN.

Status: I'm new around here
Join date: Aug 2006
Location:
Expertise:
Software:

Posts: 23

iTrader: 0 / 0%

.deMoN. is on a distinguished road

Are you using MySQL or Postgres, or ?

try not using the `'s around the table.field accessor, but rather just putting it around the field. It might be trying to find a table called 'votes.poll_id' literally.

Did the error message by any chance give you a char. number?