Re: Insert Select query problem

Thanks Jay, I had to make a change to the first part of the query to get the results that I wanted but your suggestion was definitely what I needed to get to the solution. Thanks again. For those that are interested, here's the final solution, INSERT INTO purchase (Source, Item, Qty) SELEC

Re: Insert Select query problem

Ed Reed wrote: Hi All, I have an issue that I need to resolve that is difficult to explain. I hope that someone can understand what I*m trying to do and shed some light on a solution. Here goes. I have three tables, inventory, which is a list of transactions with positive and negative value

Insert Select query problem

Hi All, I have an issue that I need to resolve that is difficult to explain. I hope that someone can understand what I*m trying to do and shed some light on a solution. Here goes. I have three tables, inventory, which is a list of transactions with positive and negative values; request, which e

Re: Insert select query problem

Luis Lebron <[EMAIL PROTECTED]> wrote: > > I am try to copy a couple of fields from one table to another. Here is my > query > > Insert into users_test (firstName, lastName) Select firstName, lastName from > users; > > The users table has 1,263 rows. However, only 1 row is inserted into > users_

Insert select query problem

I am try to copy a couple of fields from one table to another. Here is my query Insert into users_test (firstName, lastName) Select firstName, lastName from users; The users table has 1,263 rows. However, only 1 row is inserted into users_test. If I perform the following query Insert into use