Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 7/7/06, Roger <roger-FNkchr/[EMAIL PROTECTED]>
wrote:
CREATE VIEW MyStuff AS
SELECT Com . CompanyID CompID , PublicationID PubID ,
Select *
From MyStuff
Where CompID = 3562;
It looks like CompId is the column name but you
place it second in your other query. The second name
in most SQL syntax is the alias, not the real column name.
What was an alias in SELECT becomes a column name in the resulting VIEW.
This is the whole point of alias in the first place.
Igor Tandetnik
