column reference "id" is ambiguous

[siberiadev]

When I'm trying get data like the code bellow:

let query = knex.select([
		'u.id as _id',
		'u.firstName as _firstName',
		'u.avatar as _avatar',
		'u.lastName as _lastName',
		'u.gender as _gender',
		'u.userStatus as _userStatus',
		'u.dob as _dob',
		'u.email as _email',
		'u.phone as _phone',
		'u.roleId as _roleId',
		'u.password as _password',
		'u.rating as _rating',
		'u.menthorRating as _menthorRating',
		'u.marathonsCompleted as _marathonsCompleted',
		'u.marathonsCreated as _marathonsCreated',
		'u.youtube as _youtube',
		'u.instagram as _instagram',
		'u.createdAt as _createdAt',
		'u.updatedAt as _updatedAt',
		'u.deletedAt as _deletedAt',
		'u.lastName as _user_lastName',
		'm.id as _mar_id',
		'm.title as _mar_title',
		'm.description as _mar_description',
		'm.category as _mar_category',
		'm.price as _mar_price',
		'm.userId as _mar_userId',
		'm.priceType as _mar_priceType',
		'm.programElementName as _mar_programElementName',
		'm.peoplePased as _mar_peoplePased',
		'm.peopleCounter as _mar_peopleCounter',
		'm.launchedTimes as _mar_launchedTimes',
		'm.status as _mar_status',
		'm.startDate as _mar_startDate',
		'm.adminComment as _mar_adminComment',
		'm.createdAt as _mar_createdAt',
		'm.updatedAt as _mar_updatedAt',
		'm.deletedAt as _mar_deletedAt'
	])
	.from('users as u')
	.leftJoin('marathons as m', 'm.userId', 'u.id').where({id: id})
	
	console.log('QUERY', query)
	return await knexnest(query).then((data) => {
		return data
	})

I get this error:
column reference "id" is ambiguous
Is it issue for knexnest?

[shosanna]

Isn't the problem in the where clause, where you have {id: id} but you are not saying which id it is, from which table? I am not sure, I am a newbie trying to use this lib as well and I am having other problems myself :D