Old as400 system has this thing called 'Members'. Basically you can have multiple members on a table and then work with only selected one.
When you select from a table that has members you have a few options. Just doing a select will retrieve data from the first member. Or call a stored procedure to set the member for the table and retrieve it. Or create an alias for the table with members to access it. But there is no way to just get a
Is there a way to select ALL data from the table from ALL the members?