Query from different table

[earlrodson]

Can someone please help me on how to query from a different table in prestashop in backoffice?

 

i had maid a menu that should give all the list of products from a different table.

 

but i dont know how to make the query statement.. can you give me a simple script?

 

see the images below.

Edited February 8, 2013 by earlrodson (see edit history)

[NemoPS]

You can use any custom function that returns products, or even Product::getProducts() I believe

If you know sql, it should be easy anyway, just look at that getProducts to see which columns you might need, and make changes to that query where/if needed