okay, so i am a bit confused as to how to select data from an as400 because of the structure of the libraries on the as400, i have been successful
in selecting data by using
select column_name from library.table
but when i do inner joins on a query i must specify all three and i am not sure how to do this, if a library was not involved i would be doing "inner join table_name.column_name"
but i cannot inner join by doing
if the above does not make any sense, please let me know and i will try to clarify