Skip to content

Instantly share code, notes, and snippets.

@ig0r74

ig0r74/select_left_join.sql

Created March 15, 2018 17:50
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save ig0r74/a7c6d60bf5ba327a12ea1ad8db2a80dc to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save ig0r74/a7c6d60bf5ba327a12ea1ad8db2a80dc to your computer and use it in GitHub Desktop.
Download ZIP
SQl выборка с Left Join и сохранение в новую таблицу для последующего экспорта в .csv
Raw
select_left_join.sql
CREATE TABLE new_tbl AS
SELECT
2bp_customer.*, 2bp_address.company, 2bp_address.address_1, 2bp_address.address_2, 2bp_address.city, 2bp_address.postcode, 2bp_address.country_id, 2bp_address.zone_id
FROM
2bp_customer LEFT JOIN 2bp_address USING(customer_id)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment