I want to have two grid of products one that contain the products that belong to categ 1 and the second for the product that belong to categ 2. I don' t know the name of the table that contain all the attributes of products for example for customer we have the customer_grid_flat but for product every type of product have a different table that store the data please help me it's an emergency and thanks for help in every case
For products, each attribute is saved in different table as per the EAV. You can check eav_attribute table for entity_type_id=4. Check the value for the column backend_type. For example, it is int, then you should look the table for eav_attribute_int with that product id(entity_id column) and attribute_id column.
But if you have flat catalog enabled, then you can directly go to the table catalog_product_flat_1 and search with product SKU or entity_id and get the value of that attribute.