"Jeff A. Stucker" wrote:

> Instead of using SELECT * (which is almost never a good idea), select each
> field individually, and set an alias for the duplicate names. You can do
> this all in the query-by-example (QBE) grid.
>
> --
> '(' Jeff A. Stucker
> \
>
> Business Intelligence
> www.criadvantage.com
> --------------------------------------
> "Victor" <Victor@discussions.microsoft.com> wrote in message
> news:FC6E0D0B-77DE-43A8-9C65-82F3025CF679@microsoft.com...
> >I have this query:
> >
> > SELECT *
> > FROM PMA_Employee left outer JOIN
> > PMA_EmployeeAllergies ON PMA_Employee.EmployeeID =
> > PMA_EmployeeAllergies.EmployeeID
> >
> > Note, that here are two fields with EmployeeID name. When I try to create
> > report in VS, I get this error:
> >
> > More than one field in the data set 'Acudata' has the name 'EmployeeID'.
> > Field names must be unique within a data set.
> >
> > Data fields can be not unique, but field names should be unique according
> > to
> > doc.
> >
> > Is it RS problem or I do something wrong?
> >
> > I am developing reporting tool based on RS and don't know how to
> > distinguish
> > fields with the same names from different tables when they are in the same
> > dataset. If they would be in different datasets, I would use this:
> >
> > =First(Fields!EmployeeID .Value, "DataSet3")
> >
> > Can somebody from Microsoft help me please? Or anybody with good advise?
> >
> > Thanks
> >
> >
>
>