SQL view syntax for best index/summing performance

dashenk23dashenk23 Member Posts: 40

I'm new to creating SQL views for NAV and was looking for informationon the best way to sum data from a NAV table. The view will be taking data from the Job Ledger Entry table Line Amount (LCY) field and will be looking to sum data by Job, for a certain range of g/l accounts. I'm able to obtain data from the table, but it looks like it is always coming across using the primary key Entry No....any advice would be much appreciated.


Sign In or Register to comment.