x Want to participate? Join the group to interact

Sage X3

Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.

General Discussion SQL REPORT IN X3

State Suggested Answer
Replies 1 reply
Answers 1 answer
Subscribers 137 subscribers
Views 897 views
Users 0 members are here

Browse Forums

236

topics

29

replies

General Discussion

5k

topics

13k

replies

Sage Data & Analytics

56

topics

95

replies

Sage Enterprise Intelligence

210

topics

416

replies

Sage Intelligence Reporting

121

topics

322

replies

SQL REPORT IN X3

SUGGESTED

Posted By Ancient Nutrition over 5 years ago

I am trying to run the following query but its giving me an error. Any suggestion on how it can be fixed.

0 Hugo Sanguino over 5 years ago

SUGGESTED

The field NUM_0 exists in both tables, thus you need to specify the table name, i.e: SINVOICE.NUM_0
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel