# SQL Join equivalent

In the code below two dummy tables are created, usr and org.  The LeftJoin variable ("let LeftJoin"...) does the join between the tables with the FirstOrEmpty function. The result will be equal to a left join in SQL.   

```fsharp
let usr = [name: "bob", id: 45, orgid: 1001]
& [name: "bill", id: 46, orgid: 1002]
& [name: "joe", id: 47, orgid: 1002]
& [name: "Anna", id: 47, orgid: 1004]; // this org does not exist
 
 
let org = [orgname: "Ikea", id: 1001]
& [orgname: "Novacura", id: 1002]
& [orgname: "Flowington", id: 1003]; //This org has no users
  

let LeftJoin = select name, id, firstOrEmpty(org where id = orgid).orgname as orgname, orgid from usr;


let usersWithOrg = usr where any(org where id = orgid);
let usersWithoutOrg = usr where not any(org where id = orgid);




return LeftJoin;
```

The usersWithOrg  and usersWithoutOrg variables are similar to the "where in..." functionality in SQL, resulting in either the rows in the usr-table that does or does not have a corresponding row in the org table. 

By returning the different variables "LeftJoin", "usersWithOrg" or "usersWithoutOrg" in the last row in the code you can view the different results (but note as the left join yields another column from the joined table the numbers of columns in the output will be different) 


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.novacuraflow.com/development/flowscript/scripting-examples/sql-join-equivalent.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.