469,106 Members | 2,224 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,106 developers. It's quick & easy.

aliassed table trouble

Bas
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


Jul 20 '05 #1
0 1094

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.