ScottMattes
Member³
This was really weird. 
I had a SQL Window into which I pasted a query from a Report. Starting at the top I added 2 fields to be returned (g.asdf and s.fdsa), then I added the one table that wasn't already there ( something s ) and I finished up with the condition g.fld1 = s.fld1.
I then opened another SQL Window and pasted in a query from another Report. I added the same two fields at the top, but when I typed s. the field list for the table popped up! I looked and that table (something s) was not already present and when I pressed F8 I was told that s.fdsa was not defined.
I had a SQL Window into which I pasted a query from a Report. Starting at the top I added 2 fields to be returned (g.asdf and s.fdsa), then I added the one table that wasn't already there ( something s ) and I finished up with the condition g.fld1 = s.fld1.
I then opened another SQL Window and pasted in a query from another Report. I added the same two fields at the top, but when I typed s. the field list for the table popped up! I looked and that table (something s) was not already present and when I pressed F8 I was told that s.fdsa was not defined.
