Something like `select users detail address as location from kotlinlang #exposed

Something like `select users.*, detail.address as ...

tjohnn

04/27/2019, 8:24 AM

Something like

select users.*, detail.address as location from users innerjoin detail on users.id = deail.user_id

tapac

04/29/2019, 10:06 AM

@tjohnn

Copy code

val location = Detail.address.alias("location") 
val result = Users.innerJoin(Detail).slice(Users.columns + location)

tjohnn

04/29/2019, 11:14 AM

Thanks

2 Views