Llblgen pro 2.6 final.
Hi!
Im trying to convert this sql:
SELECT Count(DISTINCT UserId)
FROM
(
SELECT TP.UserId
FROM aspnet_TableProfile TP (NOLOCK)
LEFT OUTER JOIN Purchase P (NOLOCK) ON P.ToUserId = TP.UserId
WHERE P.Status = 1 AND P.Created < '2009-07-20'
UNION ALL
SELECT TP.UserId
FROM aspnet_TableProfile TP (NOLOCK)
LEFT OUTER JOIN Purchase P (NOLOCK) ON P.FromUserId = TP.UserId
WHERE P.Status = 1 AND P.Created < '2009-07-20'
)AS accounts
into llblgen. any suggestion on how to approach this?
thanks!!
