Losing data with multiple tables joining together in an ODBC NetSuite Query

When there’s many joins of tables in a ODBC NetSuite Query  I have lost data or data doesn’t show up in the query. That happened when there were 5 tables. However, when I removed 2 tables in the past, the data showed up. I was missing Sales Order data when there was 5 tables, but when there were 3 tables, the data showed up. Anyone know why I lose data if there are more than 3 tables joined together? How do I not lose data with more than 3 tables?

Rookie Asked on January 14, 2020 in Other.
Add Comment
1 Answer(s)

Can you post your query?  We use ODBC queries a lot and I have not noticed any issues with joining more than 3 tables.

Rookie Answered on January 14, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.