Hi,
Is the following a known feature / bug of EM?
Take a random table:
CREATE TABLE [dbo].[Table1] (
[Col1] [int] NULL ,
[col2] [int] NULL
) ON [PRIMARY]
GO
create a view and add that table twice (type of join is not relevant):
SELECT dbo.Table1.Col1 AS Expr1, Table1_1.col2 AS Expr2
FROM dbo.Table1 INNER JOIN
dbo.Table1 Table1_1 ON dbo.Table1.Col1 = Table1_1.Col1
Now use EM to remove the *aliassed table* in the view designer.
As opposed to what you would expect the columns from *both* the tables in
the view disappear! In the above example, no columns would be in the view.
If you remove the table without alias though, the fields from the aliassed
table stay in the view.....
A related problem (that I can't seem to reproduce) is that sometimes EM
seems to forget which columns come from what table/alias and uses the wrong
table to take the columns from.
Funny eh?
Cheers,
Bas