SQL iki tabloyu birleştirme

PHOTO EMBED

Fri Dec 11 2020 11:39:30 GMT+0000 (Coordinated Universal Time)

Saved by @ozgunn #sql #mysql

SELECT id, account_id, amount, created_at, null as type
 	FROM subscription_invoice
UNION ALL
SELECT id, account_id, amount, created_at, 
	`type` as type
FROM subscription_payment
ORDER BY created_at DESC
content_copyCOPY