Skip to content

Instantly share code, notes, and snippets.

@jeffschulthies
Last active August 30, 2016 19:55
Show Gist options
  • Save jeffschulthies/b17f661b11d75e13851a3f2775b29282 to your computer and use it in GitHub Desktop.
Save jeffschulthies/b17f661b11d75e13851a3f2775b29282 to your computer and use it in GitHub Desktop.
Vero SQL
-- Inventory DB (MySQL)1
;
CREATE TEMPORARY TABLE `QBCW5ISAJ` AS
SELECT `t0`.`product_id` `productid`
FROM
`inventory`.`daily_unit_level` `t0`
;
-- Engine Block: EBJYF5VRO
;
CREATE TEMPORARY TABLE "EBJYF5VRO" AS (
SELECT "t0"."ProductID" "productid"
FROM
"public"."products" "t0"
) WITH DATA;
-- Result Block
;
SELECT
"t0"."productid" "productid",
"t1"."productid" "inventory_db__mysql_1_productid"
FROM
"EBJYF5VRO" "t0"
FULL JOIN "QBCW5ISAJ" "t1" ON (("t1"."productid" = "t0"."productid"))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment