e g ```SELECT from A B C WHERE A id = B id AND B id = C id`` kotlinlang #coroutines

e.g. ```SELECT * from A, B, C WHERE A.id = B.id ...

parth

10/22/2021, 7:54 PM

e.g.

Copy code

SELECT * from A, B, C
  WHERE A.id = B.id
  AND B.id = C.id

ursus

10/22/2021, 8:31 PM

hmm, but they're not related, A, B, C have no common columns

parth

10/22/2021, 8:32 PM

sure that was just an example, as long as you have a way to query A, B, and C, you can add those as filters using

WHERE / AND

ursus

10/22/2021, 9:02 PM

oh I see, I didnt know you can have multiple tables in from clause like that