Is there a way to query a pivot table in the DB builder(Not eloquent)

Hello,

I am looking at the doc and I cannot find a way in the DB query pages to get the data from a pivot table. Any idea how to do this please?

Is there not something like ->wherePivot(tablename, id, id) ?

Thank you.

Level 10

I am wondering if the "Union" would not be the way forward with the DB query?

Level 1

Level 10

Thanks, I see, so the pivot can be accessed without any issues with a join....interesting.

Thanks again.

Please or to participate in this conversation.