Hi All
Here’s the scenario:
- I have a “Job” table with a column named “Sales,” which is intended to reference the “User Manager” table.
- In the “User Manager” table, I have columns for “Role” and “Name.”
My goal is to fetch the names from the “User Manager” table where the role is set to “Sales” in the “Job” table’s “Sales” column. However, when I use the SELECT() function, I encounter an error related to using a list type instead of a reference type.
Could someone please provide guidance on how to correctly use the SELECT() function to retrieve “User Manager” names based on the “Sales” role in the “Job” table while avoiding the list type error? Any suggestions, examples, or insights would be immensely helpful!
Thank you very much for your assistance!
