Strange SQL query behavior

[Piotrek]

Hi all,

I’m using EA 7.1.827 + MySQL 5
I was trying to make a simple query that lists all requirements I have in model, and packages they are in.
Simple query looks like this:
SELECT t_package.Name, t_object.Name, t_object.Object_Type
FROM t_package LEFT JOIN t_object ON t_package.Package_ID = t_object.Package_ID
WHERE t_object.Object_Type="Requirement";

When run in EA it displays the same values for both “Name” fields. Both have values from t_object table.
I was trying to figure out, what’s going on, and I have changed order of fields in query.
SELECT t_object.Name, t_package.Name, t_object.Object_Type …. (rest stays the same)

Now the results are different. Again the same values are displayed in both “Name” fields, but this time these are values from t_package table.

Is there known solution, how to make such query work?

Regards,
Piotrek

[Eve]

You'll need to provide an alias for one or both columns.

SELECT t_package.Name as PackageName, t_object.Name, t_object.Object_Type
FROM t_package LEFT JOIN t_object ON t_package.Package_ID = t_object.Package_ID
WHERE t_object.Object_Type="Requirement";

[Piotrek]

Thanks a lot! It helped. I should have thought about adding aliases.

Thank you,
Piotr