Rank: Newbie
Groups: Registered
Joined: 6/4/2018(UTC) Posts: 1 
|
Hi! It's nice for you to provide this excelent tool for us! I got a problem as below:
Table "HoldInfo" has 3 columns "Reason" , "TxnUserID" while "TxnUserID" and "HoldToUserID" can be null.
Table "UserInfo" has 2 columns "UserID" and "UserName". I want to get.a datatable like "Reason","Txn User Name","HoldUserName". But the generated sql is not correct : SELECT ... FROM (UserInfo1 Left out join (HoldInfo Left Outer Join UserInfo 2 on. .) on. ..),So I can not get the datas whose txnuserid is null.
I.have config 3 tables "HoldInfo","UserInfo1","UserInfo2" and 2 left out joins in designer.
Can you help to fix it!
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Can you make a sample with Northwind, and attached the report showing the problem ?
Thanks.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
