[PHP-DB] Conditional INNER JOIN

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

Re: [PHP-DB] Conditional INNER JOIN

On 5/24/08, Ron Piggott [EMAIL PROTECTED] wrote: 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 =

Re: [PHP-DB] Conditional INNER JOIN

This still isn't working; am I close? 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 ) CASE shopping_cart_sales_shipping_address.same_as_customer WHEN

Re: [PHP-DB] Conditional INNER JOIN

On 5/24/08, Ron Piggott [EMAIL PROTECTED] wrote: This still isn't working; am I close? 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 ) CASE