Because I should be able to state which table is authoratative or the first could be or have a clause or a flag or something in order to not have to list each specific field or write 20 lines of code in addition to what would normally be my SQL. But there's not, so I have to decide whether it is worth it.

>Also, how does the function know which of the two equal fieldnames You like to have?
>If You have SUPPLIER and PRODUCTS and both of them have a field "NAME", do You want the
>Supplier's name or the Product-Name.