CODEWITHSUNDEEP
c#sql.netdatabaseleft-join
Beep
Beep

Reputation: 2823

LEFT OUTER JOIN problems

I have a error I relay cant understand, if some one could explain to me the problem as its preventing me from progressing with my program.

the error is saying i have a syntax error on the JOIN

Code

using (OleDbDataAdapter query_prof = new OleDbDataAdapter("SELECT aspnet_Users.AplicationId, aspnet_User.UserName, aspnet_User.LastActivityDate FROM (aspnet_Users LEFT OUTER JOIN UserProfile ON aspnet_User.UserName = UserProfile.UserName) WHERE (UserProfile.UserName IS NULL)", conn))
{
    query_prof.Fill(dt);
}

Upvotes: 0

Views: 110

Answers (1)

PeterRing
PeterRing

Reputation: 1797

Leave out the parenthesis from the from clauses:

FROM (aspnet_Users LEFT OUTER JOIN UserProfile ON aspnet_User.UserName = UserProfile.UserName)

you should do :

FROM aspnet_Users LEFT OUTER JOIN UserProfile ON aspnet_User.UserName = UserProfile.UserName

Upvotes: 4

Related Questions