Guest Posted June 1, 2003 Posted June 1, 2003 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: 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 Could some kind sould advise me as to 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...! I just noticed column_right has disappeared! I kind of remember that the column is initiated after the bit that is going wrong, so I guess if I can fix that then all will be okay... Thanks for any help!
rseigel Posted June 1, 2003 Posted June 1, 2003 Why would you want to do that? :? That goes against all sensible database design rules.
Guest Posted June 1, 2003 Posted June 1, 2003 Because, apart from the one error message, everything works fine and is much easier for me in terms of editing the products table with having just the one monitor. I need it to be functional in a bespoke context, not sensible... :lol: Any ideas?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.