Idea

asb.p avatar image
12 Likes"
asb.p suggested Jon Abbott edited

Add the functionality of Left Join, Right Join and Full Outer Join capabilities to Table.query()

Hoping to consider the requirement.

You can see the following link for more details

SQL Command for Left Join in Flexsim

querysqlsql queriestablejoin
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Comment

Jon Abbott avatar image
0 Likes"
Jon Abbott commented Jon Abbott edited

@phil.bobo

@anthony.johnson

@jordan.johnson

I second this idea. It would be very useful to have additional SQL JOIN functionality in Table.query(), as well as DISTINCT. I know another person who would benefit from this as well.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Your Opinion Counts

Share your great idea, or help out by voting for other people's ideas.

Related Ideas

Adding the original row in the SQL query table to the dumpquery table by default/optional

Allow querying an empty Global Table

Can DISTINCT be added as a keyword for queries?

Flexsim SQL Wishlist: NOT predicate, LEFT JOINs, DISTINCT, UNION, CRUD support

Adding foreign keys in Global Tables to maintain data integrity

(Multi-line) Query Editor

Add name property to Table

[feature request] Table.sort should use a stable sort algorithm

Adding SQL Queries As a Drag Drop Library