join left on多张表,使用LEFT OUTER JOIN连接多个表

I'm trying to get data from multiple tales using LEFT OUTER JOIN but I'm getting a fatal error.

Table names, field names, db connection are correct.

$sql = "SELECT shipping_info.shipping_id, service1.service, package1.package_type, countries1.country AS fromCountry, countries2.country AS toCountry, countries3.country AS resiCountry, customer1.name,

FROM shipping_info

LEFT OUTER JOIN service_types AS service1 ON shipping_info.service_type = service_types.serviceType_id

LEFT OUTER JOIN package_types AS package1 ON shipping_info.package_type = package_types.packageType_id

LEFT OUTER JOIN customer_info AS customer1 ON shipping_info.customer_id = customer_info.customer_id

LEFT OUTER JOIN countries AS countries1 ON shipping_info.from_loc = countries1.country_id

LEFT OUTER JOIN countries AS countries2 ON shipping_info.to_loc= countries2.country_id

LEFT OUTER JOIN countries AS countries3 ON shipping_info.to_id = countries3.country_id

ORDER BY shipping_info.order_date DESC";

Fatal error: Call to a member function fetchAll() on a non-object in....

解决方案

try changing your query to this:

SELECT s1.shipping_id,

s1.service,

p1.package_type,

c1.country fromCountry,

c2.country toCountry,

c3.country resiCountry,

c1.name

FROM shipping_info si

LEFT JOIN service_types s1 ON si.service_type = s1.serviceType_id

LEFT JOIN package_types p1 ON si.package_type = p1.packageType_id

LEFT JOIN customer_info c1 ON si.customer_id = c1.customer_id

LEFT JOIN countries c1 ON si.from_loc = c1.country_id

LEFT JOIN countries c2 ON si.to_loc= c2.country_id

LEFT JOIN countries c3 ON si.to_id = c3.country_id

ORDER BY si.order_date DESC;

you had multiple typos in the query itself with incorrect syntax.. also LEFT OUTER JOIN and LEFT JOIN are exactly the same

Also can you post how you are executing this query? you may have an issue with the actual method for executing it.