Maybe....
the strange results caming out from the following queries:
1) In this query I've some rows in Users and no related rows in UserPortals
select a.portalid, a.userportalid,a.UserID, b.DisplayName, b.UserId, b.UserName, b.eMail from users b left outer join userportals a on (b.userid=a.userportalid)
2) In the floowing the opposite, I've some rows in UserPortals and no related rows in Users select a.portalid, a.userportalid,a.UserID, b.DisplayName, b.UserId, b.UserName, b.eMail from userportals a left outer join users b on (b.userid=a.userportalid)
Then in both case whene I've the right correspondece, I've sometimes a wrong PortalID...but the behaeviour is corret even if the PortalID is another one
...is it normal?
Thanks
Vincenzo