 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
judahr
Joined: 09 Mar 2007
Posts: 319
Country: United States |
|
 SQL 6 Beta Table Preview - wrong table |
 |
v6.0.33 Beta
 |
 |
Select USState
From dbo.Table1 t1
Where not exists (Select *
From dbo.UsState t2
Where t1.USState = t2.StateCode) |
If you Control-Click on any of the UsState named items, it will only show you the values from this query:
Select UsState
From dbo.Table1 t1
If you ctrl-click on the table UsState it should show you the contents of the entire table.
|
|
| Thu Jul 07, 2011 3:27 pm |
  |
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7849
|
|
| |
|
Thank you. I'm going to log this issue to our tracking system
|
|
| Thu Jul 07, 2011 4:04 pm |
|
|
judahr
Joined: 09 Mar 2007
Posts: 319
Country: United States |
|
| Still an issue |
|
v6.0.42
If you ctrl-click the table name in a join it does a select distinct from the column name instead.
|
|
| Thu Jul 21, 2011 10:42 am |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
