I use TDP 4.3 and this issue has been present for a while.
I have a table that is structured something like this:
So the data could look like this:
G1234, A0005, A0005, Doe, John
G1234, A0005, A0003, Doe, Jane
G1234, A0005, A0001, Doe, Boy
Uniqueness is the first 3 columns. But I want the LastName and FirstName of the account holder to be on every row I return. So I write a query like this:
SELECT A.Group_ID, A.Account_ID, A.MemberID, A.LastName As MemberLastName, A.FirstName as MemberFirstName, B.LastName as OwnerLastName, B.FirstName as OwnerFirstName
FROM memberdata A
INNER JOIN memberdata B
ON A.Group_ID = B.Group_ID AND A.Account_ID = B.Account_ID;
As I’m typing the query in the editor window, everything with an “A” alias will let me auto complete. I type in A “dot” and a list of fields will pop up allowing me to select what field I want. However nothing with the “B” alias does this.
Hoping there is a setting somewhere I missed, or maybe this is a bug?