|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Correlation Names... help!!!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Correlation Names... help!!!
|
|
|
| Hey everyone,
I'm getting this error when adding this to a VIEW in SQL Server 2000:
Tables or functions 'dbo.APPLICATION_RELEASES' and
'dbo.APPLICATION_RELEASES' have the same exposed names. Use the
correltation names to distinguish them.
dbo.APPLICATION_RELEASES ON dbo.TICKET_HEADER.APPLICATION_ID =
dbo.APPLICATION_RELEASES.APPLICATION_ID AND
dbo.TICKET_HEADER.ASSIGNED_RELEASE_ID =
dbo.APPLICATION_RELEASES.RELEASE_ID LEFT OUTER JOIN
dbo.APPLICATION_RELEASES ON dbo.TICKET_HEADER.APPLICATION_ID =
dbo.APPLICATION_RELEASES.APPLICATION_ID AND
dbo.TICKET_HEADER.FOUND_IN_RELEASE_ID =
dbo.APPLICATION_RELEASES.RELEASE_ID LEFT OUTER JOIN
I have tryed writing an alias like dbo.APPLICATION_RELEASES_1 but SQL
Server says "Invalid object name".
Thanks a million!
-Ray
| |
| Tibor Karaszi 2002-11-29, 3:23 am |
| After the table name, you do " AS alias_name". Like:
FROM authors AS a
JOIN titles AS t ON...
WHERE
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Ray" <genius99@hotmail.com> wrote in message
news:40f88e2e.0211290025.ea37ef4@posting.google.com...
> Hey everyone,
>
> I'm getting this error when adding this to a VIEW in SQL Server 2000:
> Tables or functions 'dbo.APPLICATION_RELEASES' and
> 'dbo.APPLICATION_RELEASES' have the same exposed names. Use the
> correltation names to distinguish them.
>
> dbo.APPLICATION_RELEASES ON dbo.TICKET_HEADER.APPLICATION_ID =
> dbo.APPLICATION_RELEASES.APPLICATION_ID AND
> dbo.TICKET_HEADER.ASSIGNED_RELEASE_ID =
> dbo.APPLICATION_RELEASES.RELEASE_ID LEFT OUTER JOIN
>
> dbo.APPLICATION_RELEASES ON dbo.TICKET_HEADER.APPLICATION_ID =
> dbo.APPLICATION_RELEASES.APPLICATION_ID AND
> dbo.TICKET_HEADER.FOUND_IN_RELEASE_ID =
> dbo.APPLICATION_RELEASES.RELEASE_ID LEFT OUTER JOIN
>
> I have tryed writing an alias like dbo.APPLICATION_RELEASES_1 but SQL
> Server says "Invalid object name".
>
> Thanks a million!
>
> -Ray
| |
|
| Thanks Tibor! I got it working!
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se> wrote in message news:<OZGBwb4lCHA.1928@tkmsftngp07>...
> After the table name, you do " AS alias_name". Like:
>
> FROM authors AS a
> JOIN titles AS t ON...
> WHERE
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
>
>
> "Ray" <genius99@hotmail.com> wrote in message
> news:40f88e2e.0211290025.ea37ef4@posting.google.com...
> > Hey everyone,
> >
> > I'm getting this error when adding this to a VIEW in SQL Server 2000:
> > Tables or functions 'dbo.APPLICATION_RELEASES' and
> > 'dbo.APPLICATION_RELEASES' have the same exposed names. Use the
> > correltation names to distinguish them.
> >
> > dbo.APPLICATION_RELEASES ON dbo.TICKET_HEADER.APPLICATION_ID =
> > dbo.APPLICATION_RELEASES.APPLICATION_ID AND
> > dbo.TICKET_HEADER.ASSIGNED_RELEASE_ID =
> > dbo.APPLICATION_RELEASES.RELEASE_ID LEFT OUTER JOIN
> >
> > dbo.APPLICATION_RELEASES ON dbo.TICKET_HEADER.APPLICATION_ID =
> > dbo.APPLICATION_RELEASES.APPLICATION_ID AND
> > dbo.TICKET_HEADER.FOUND_IN_RELEASE_ID =
> > dbo.APPLICATION_RELEASES.RELEASE_ID LEFT OUTER JOIN
> >
> > I have tryed writing an alias like dbo.APPLICATION_RELEASES_1 but SQL
> > Server says "Invalid object name".
> >
> > Thanks a million!
> >
> > -Ray
|
|
|
|
|