I added indexes to Field1 and Field2 in both tables (Table1 and Table2) and no have nulls:
This is working:
1. but when i try to use only JOIN (without INNER string) i am getting error, why?
2. When i do not have indexes on Field1 and Field2 in Table3 and Table4 i can use...