SQL dataset with duplicate names on join?

Question & Answer
1

hello,

I’m trying to create a simple dataset in the format of

select * from user u left join usersettings us on u.userId = us.userId

upon clicking apply I get

sourceErrorMessage:Duplicate column name ‘userId’

Whats the correct way around this?

2

You will need to do something like this

select u.*, us.userId us_userid from user u left join usersettings us on u.userId = us.userId

This will get you all columns from user and only userid from usersettings. You will need to select all the other columns from usersettings in the select statement if you want to use them and make sure there are no duplicates. If there are then you need to rename them.