I have run the SQL with some joins and as the result I had two columns named name:
SELECT
competitor.*,
club.name,
class.name
FROM ...
As a result I got two columns with same name and same values (both had class.name values). This was not the case when I tried to run the same SQL on database directly.
The solution is simple - just set some different aliases for those columns:
SELECT
competitor.*,
club.name AS club_name,
class.name AS class_name
FROM ...


No comments:
Post a Comment