I have a tableA with two references, how can I query this table like: `TableA.selectAll().where(Tabl...

# exposed

[rapho]

I have a tableA with two references, how can I query this table like:
TableA.selectAll().where(TableA.ref1 = object1 and TableA.ref2= object2)

[rapho]

Currently i do

ref1.tableA.filter { ref2 != object2 }

But I guess I could also do this with exposed

[tapac]

TableA.select { TableA.ref1 eq object1 and (TableA.ref2 eq object2) }

https://github.com/JetBrains/Exposed/wiki/DSL#read

[rapho]

I'm trying but somehow I cant use eq, and I dont know why.

[tapac]

what is the game? If it's Entity then you have to write eq game.id

[rapho]

object GameAnswers : IntIdTable() {
    val game = reference("game", Games)
    val user = reference("user", Users)

Thats the table

[rapho]

Aha

[rapho]

Interesting, didn't know! Yes with id it works

[rapho]

Thanks