I'd love to know what is wrong with this query...
Posted: Mon Jul 03, 2006 6:15 pm
Considering this is always how I write joins and they have always worked before...

Code: Select all
$FetchOptionsQuery = "select `products_options_values_id`, `products_options_values_name` ";
$FetchOptionsQuery .= "from `products_options_values` ";
$FetchOptionsQuery .= "join `products_options_values_to_products_options` ";
$FetchOptionsQuery .= "on (`products_options_values`.`products_options_values_id` = `products_options_values_to_products_options`.`products_options_values_id`) ";The query..#1064 - You have an error in your SQL syntax near 'on ( `products_options_values` . `products_options_values_id` = `products_options_value' at line 1
Code: Select all
select `products_options_values_id`, `products_options_values_name` from `products_options_values` join `products_options_values_to_products_options` on (`products_options_values`.`products_options_values_id` = `products_options_values_to_products_options`.`products_options_values_id`)