473,388 Members | 904 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 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 1155

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Jon Anunson | last post by:
Hi - Ok, i know this isn't ideal, but i'm trying to get a quick job done and having a little trouble, so i've reverted to table layout hoping that would help... here's the problem: to solve some...
1
by: ferraro.joseph | last post by:
Hi, I'm querying Salesforce.com via their AJAX toolkit and outputting query results into a table. Currently, their toolkit does not possess the ability to do table joins via their structured...
3
by: rinu911 | last post by:
hi all I am tring to insert a values to a table by checking if the value is there in the table already but it gives me this error "Query input must contain at least one table or query" ...
8
by: ananthaisin | last post by:
How to reduce the table size for any table while using truncate or delete statements. In oracle 8i it was truncating the storage space but in 10g it is not .... I have given truncate statement in...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

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.