join with duplicate column nnames in both tables

[sputs]

Hi,

I am trying to execute this query that runs fine in mysql:

Code: Select all

SELECT states.*,
               countries.name AS name_country 
FROM states 
JOIN countries ON states.country_id = countries.id 

I have figured out that the join statement is causing issues in nuBuilder (but not in mysql). Both tables have a column called id. I suspect this is the issue. I am not able to change the names because this is tied to lots of other apps.

Anyone have any ideas on what I could try to get this working?

[kev1n]

Hi,

Check out this thread:

https://forums.nubuilder.cloud/viewtopic. ... 48&p=23803

[sputs]

Thank Kevin! Will likely solve it.