clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591671 fiddles created (45716 in the last week).

SELECT a.CustomerID , a.FirstName , a.LastName , b.PhoneID , b.CustomerID , b.PhoneNumber , b.PhoneNumberType FROM ( SELECT 1000 AS CustomerID , 'Mickey' AS FirstName , 'Mouse' AS LastName ) AS a INNER JOIN ( SELECT 2000 AS PhoneID , 1000 AS CustomerID , '8880001111' AS PhoneNumber , 'Home' AS PhoneNumberType UNION SELECT 2001 AS PhoneID , 1000 AS CustomerID , '8889990000' AS PhoneNumber , 'Mobile' AS PhoneNumberType ) AS b ON a.CustomerID = b.CustomerID;
CustomerID FirstName LastName PhoneID CustomerID PhoneNumber PhoneNumberType
1000 Mickey Mouse 2000 1000 8880001111 Home
1000 Mickey Mouse 2001 1000 8889990000 Mobile
 hidden batch(es)