SQL OF MY LOVE LIFE: PART IX

/* GREEN */
SELECT MINE = COUNT (DISTINCT MINE)
,HIS = COUNT (DISTINCT HIS)
INTO MYLIFE..LOVELIFE_INTROUBLE
FROM (
SELECT MINE = my.PARTNER_FULL_NM
,HIS = people.PARTNER_FULL_NM
FROM MYLIFE..LOVELIFE_HUSBAND my
join EARTH.. PEOPLE_PARTNER people
on my.PARTNER_FULL_NM = people.PARTNER_FULL_NM
)
/* 1 row; 5 years */

Advertisements
Tagged , , , , , , , ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Advertisements
%d bloggers like this: