Conditional INNER JOIN

[email protected] (Ron Piggott)
Newsgroups php.db
Organization Acts Ministries Christian Evangelism
Message-ID <[email protected]>
Is it possible to do a conditional INNER JOIN ?

So far I have 

SELECT * FROM ( shopping_cart_orders INNER JOIN
shopping_cart_sales_shipping_address ON
shopping_cart_orders.shipping_address_reference =
shopping_cart_sales_shipping_address.reference )

If shopping_cart_sales_shipping_address.same_as_customer has a value of
"0" I need to 

INNER JOIN shopping_cart_sales_billing_address WHERE
shopping_cart_sales_billing_address.shipping_address_reference =
shopping_cart_sales_shipping_address.reference

otherwise the shipping address is the same as the billing address.
Suggestions?

Ron
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.