jubez Posted January 22, 2009 Share Posted January 22, 2009 Hello, I need to fix my SQL table, can someone please point me in the right direction. I am using phpMyAdmin. I am assumeing that the error is with the joining of two columns. Thank you. Angie 1052 - Column 'customers_fax' in field list is ambiguous select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, o.customers_telephone, o.customers_email_address, customers_address_format_id, customers_group_name, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified, cp_tracking, customers_id, customers_fax from orders o left join customers using(customers_id) left join customers_groups using(customers_group_id) where orders_id = '16' [TEP STOP] Link to comment Share on other sites More sharing options...
dickysolo Posted January 22, 2009 Share Posted January 22, 2009 Hello, I need to fix my SQL table, can someone please point me in the right direction. I am using phpMyAdmin. I am assumeing that the error is with the joining of two columns. Thank you. Angie 1052 - Column 'customers_fax' in field list is ambiguous select customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, o.customers_telephone, o.customers_email_address, customers_address_format_id, customers_group_name, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value, date_purchased, orders_status, last_modified, cp_tracking, customers_id, customers_fax from orders o left join customers using(customers_id) left join customers_groups using(customers_group_id) where orders_id = '16' [TEP STOP] u are using 3 tables.right? customers,orders and customers_groups. I think (in your DB) in the orders table you have another column "customers_fax". So if the "customers_fax" u wanna use is from orders table then use o.customers_fax else c.customers_fax. Just back up and check once again Link to comment Share on other sites More sharing options...
jubez Posted January 22, 2009 Author Share Posted January 22, 2009 u are using 3 tables.right? customers,orders and customers_groups. I think (in your DB) in the orders table you have another column "customers_fax". So if the "customers_fax" u wanna use is from orders table then use o.customers_fax else c.customers_fax. Just back up and check once again Yes I do have Customer Groups, so do I make the changes to the table or the php file, or both? Thanks :) Link to comment Share on other sites More sharing options...
jubez Posted January 22, 2009 Author Share Posted January 22, 2009 Yes I do have Customer Groups, so do I make the changes to the table or the php file, or both? Thanks :) I followed your directions and changed in Customers_Groups the customers_fax to o.customers_fax in MySQL and it works great! My site is going live today!! Thank you so much! :D Link to comment Share on other sites More sharing options...
dickysolo Posted January 22, 2009 Share Posted January 22, 2009 I followed your directions and changed in Customers_Groups the customers_fax to o.customers_fax in MySQL and it works great! My site is going live today!! Thank you so much! :D my pleasure :) Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.