how to do a where expression function that references a joined table?

[matthewkooshad]

i noticed in my where expression, the param to the function is referring to the table i have the select on, but i have inner joined a 2nd table that i need write some where conditions on. can you give an example on this?
i see join here but not using where with it for what i'm trying to do: https://moor.simonbinder.eu/docs/advanced-features/joins/

[simolus3]

I've added documentation for this here.
Basically, you can call where after .join(). It works similar to regular where clauses, except that you have to specify the table directly:

// no join:
select(table)..where((row) => row.id.equals(3))

// join
final query = select(table).join([...]);
query.where(table.id.equals(3));

If you need help with a specific query let me know!

[matthewkooshad]

thanks @simolus3 that helped me, but i think need to use ..where in another case after .join. i've opened up a new discussion, on this #1274, since i think your answer here answers this q that i asked, trying to make my learning to be helpful search results for others.