By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,158 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

New table and adding primary key

P: n/a
When making a new table from a query how in Access do a create a primary key.

IE:

SELECT
Item.StockCode,
Item.LongDesc,
step1.Style,
step1.AltStyle,
step1.StyleType,
step1.Notes,
Item.ProdClass,
step1.LGTH

INTO step2

FROM
Item RIGHT JOIN
step1
ON LEFT(Item.StockCode,step1.LGTH) = step1.Style
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ps******@ibbgold.com (Paul Sparrow) wrote in message news:<4d**************************@posting.google. com>...
When making a new table from a query how in Access do a create a primary key.

IE:

SELECT
Item.StockCode,
Item.LongDesc,
step1.Style,
step1.AltStyle,
step1.StyleType,
step1.Notes,
Item.ProdClass,
step1.LGTH

INTO step2

FROM
Item RIGHT JOIN
step1
ON LEFT(Item.StockCode,step1.LGTH) = step1.Style

AFAIK, manually. You can't do it with a query. You can do it with
DDL, not DML SQL.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.