Add inner join example to reference docs

[gregnr]

Improve documentation

Link

Each of these client lib reference docs:

• https://supabase.com/docs/reference/javascript/select
• https://supabase.com/docs/reference/python/select
• https://supabase.com/docs/reference/swift/select
• https://supabase.com/docs/reference/kotlin/select

Describe the improvement

These should include an example on how to do inner joins as the Dart and C# docs do:

• https://supabase.com/docs/reference/dart/select
  

• https://supabase.com/docs/reference/csharp/select
  

Additional context

Examples are defined under each ./spec/supabase_<lang>_<version>.yml file. Eg. JavaScript:

supabase/spec/supabase_js_v2.yml

Line 1129 in 843d4e0

examples:

Let's also change the "Filtering through foreign tables" examples to use inner.

[SamantaTarun]

I'd like to work on it.

[gregnr]

@tarunsamanta2k20 that'd be great!

[SamantaTarun]

How do I run the query after preparing to test if it works?

[SamantaTarun]

Also if you have any references for writing language specific query then please mention the link over here.

[gregnr]

Hey @tarunsamanta2k20, feel free to follow our guide on creating API routes and querying them (specifically under "REST API"):
https://supabase.com/docs/guides/api/creating-routes

This should help you get started for JavaScript, but the same logic will apply to other languages. Also each language includes install instructions:
https://supabase.com/docs/reference/javascript/installing

[danielbolivar]

I would like to know if this issue has been solved. If not, may I work on it?

[gregnr]

This issue is still open!

[bk7312]

I encountered a similar issue (in JS) when trying to filter via a foreign table, the docs mentioned something about using !inner and it wasn't obvious how to do it. Managed to figure it out and made a PR #17387 to add an example.

Also, it seems like @danielbolivar's PR #15438 is still open?