Help with SQL Query Report
Hi Everyone,
Please could you help me with some SQL code so I can generate a report. What I would like to do is:
List all Assets in any category with a purchase price of less than �500 and also add the column Life of Asset (This field I create through the asset system so I don't know what table this is or where it's stored that's the biggest problem)
Thanks
Please could you help me with some SQL code so I can generate a report. What I would like to do is:
List all Assets in any category with a purchase price of less than �500 and also add the column Life of Asset (This field I create through the asset system so I don't know what table this is or where it's stored that's the biggest problem)
Thanks