SELECT T.Col1,
ISNULL(A.Request,0) AS Request1,
ISNULL(A.Due,0) AS Due1,
ISNULL(B.Request,0) AS Request2,
ISNULL(B.Due,0) AS Due2,
ISNULL(C.Request,0) AS Request3,
ISNULL(C.Due,0) AS Due3
FROM
(
SELECT Col1
FROM #TmpA
UNION
SELECT Col1
FROM #TmpB
UNION
SELECT Col1
FROM #TmpC
)T
LEFT JOIN #TmpA A
ON A.Col1=T.Col1
LEFT JOIN #TmpB B
ON B.Col1=T.Col1
LEFT JOIN #TmpC C
ON C.Col1=T.Col1
if (isGooglePlayServicesAvailable (this)) {
MobileAds.initialize (this, appid);
}
public boolean isGooglePlayServicesAvailable (Context context) {
GoogleApiAvailability googleApiAvailability = GoogleApiAvailability.getInstance ();
int resultCode = googleApiAvailability.isGooglePlayServicesAvailable (context);
return resultCode == ConnectionResult.SUCCESS;
}