Select query with an auto number of 1

[KenshiroUK]

A simple select query to place an auto number of 1 in a field.

Hi guys, not sure what the code is but I just wish to create a simply select query that uses an auto number of 1 in a field.

Basically we have orders being downloaded yet they have no quantity purchased, but each order is treated as an individual order so it will be 1.

at the moment I have order-id, item-name, listing-id, sku and I wish for qty-purchased always as 1.

Can anybody help me please?

 

[James Dudden]

Add a new column to the query and in the field put this:

AutoQty:1