1052 - Column: 'products_date_available'

This message was sent from: Development
http://forums.oscommerce.com/viewtopic.php?p=175360#175360
----------------------------------------------------------------

Hello all,

I have been trying to consolidate three tables referring to the product lines in my shop (products/product_description and product_to_categories) into one table that I have labellled "product_lines".

Everthing works having just tested it, but I keep getting this error on the main page:

[b]1052 - Column: 'products_date_available' in field list is ambiguous

select p.products_id, pd.products_name, products_date_available as date_expected from product_lines p, product_lines pd where to_days(products_date_available) >= to_days(now()) and p.products_id = pd.products_id and pd.language_id = '1' order by date_expected desc limit 6[/b]

Could some kind sould tell me what bits I need to fiddle with in order to get this message to disappear. I managed to figure out everything else, but I am now kerfuddled...!

Thanks for any help!