Sql Query

[bebijuteria]

This is to export to excel a file that have this fields from a zen-cart.

This fields are in the same table?

[nomadrw]

do you need to create a table in you db
or
do you want to view your fields in the db
nomad

[bebijuteria]

I need to view this fiels to copy to a excel fine.
So i can integrate in a e-marketplace.

[nomadrw]

If the fields exist in that table
then you can do this
select * from abc;

abc will be your table name.
this will list all the fields within that table.
you can also do an order by which will list all the fields in order.
it migh look something like this
select * from abc order by category; (or it could be by name of the product, products_id)

Where are you going to write this SQL at.
If you have XAMMP that is were I would write it
This is only a temp SQL script
nomad

[bebijuteria]

I have this query

I think that this will give me part of what i need. But now is give me timout


SELECT `products`.`products_id`,`products`.`products_image`,`products`.`products_status `, `products_description`.`products_name`, `products_to_categories`.`categories_id`
FROM products, products_description, products_to_categories

[poolprorich]

Hello,

You can't select products from products:

SELECT products_name, products_description, products_url,  products_id,products_quantity, products_model, products_image,products_price,products_virtual, products_weight,   products_date_added, products_last_modified, products_date_available, products_status, products_tax_class_id,  manufacturers_id,        products_quantity_order_min, products_quantity_order_units,   products_priced_by_attribute,     product_is_free, p.product_is_call, products_quantity_mixed,  product_is_always_free_shipping, products_qty_box_status,  products_quantity_order_max,  products_sort_order,  products_discount_type, products_discount_type_from,
products_price_sorter FROM  products, product_description
                              WHERE products_id = ''

And you have periods in place of comas
Rich

[bebijuteria]

With your query i get:

Column 'products_id' in field list is ambiguous


And i have to ad:

products_to_categories in the FROM

like this:

FROM products, products_description, products_to_categories