471,893 Members | 1,476 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,893 software developers and data experts.

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 1131

This discussion thread is closed

Replies have been disabled for this discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.