Ah, yes, I'm sorry: I mistyped.  I have "titleID" and "artistID" in that 
table.



Puneet Kishor wrote:
>
>
> George Roberge wrote:
>> Greetings, all.
>>
>> I'm having trouble getting an insert statement to function properly, and
>> am not sure if it is me, or this isn't supposed to be done.
>>
>> This is not the complete database, but to keep this issue simple:
>>
>> I have three tables:
>>
>> artists (artistID integer, lastname text) contains 1, 'Weaver'
>> titles (titleID integer, title text) contains 1, 'Alien'
>> cast (castID, artistID)
>
>
> Note the definition of the table 'cast' -- it has columns 'castID' and 
> 'artistID')
>
>>
>> I am experimenting with inserting data into the cast table using values
>> that will be entered either by a user or selected from a list.  In the
>> meantime, I am manually entering the values "Weaver" and "Alien" to
>> acquire title ID number and artist ID to store into the cast table.
>>
>> This simple statement works fine and yield the expected "1": insert into
>> cast (titleID) select titleID from titles where title='Alien';
>>
>> I get into trouble when I attempt to add the extra field: insert into
>> cast (titleID, castID) select titleID from titles where title='Alien'
>
>
> Note what you are trying to insert into cast above, namely 'titleID' 
> and 'castID'. Per your table definition, you have no 'titleID' in the 
> table 'cast'
>
>
>> select artistID from artists where lastname='Weaver';
>>
>> I know that the above syntax is incorrect.  I have tried adding
>> parentheses around the select statements (SELECT XXX), (SELECT XXX) and
>> have tried the UNION in between, which I now understand adds separate
>> rows into the table.  I assumed that I could replace simple values with
>> SELECT statements, but either I am wrong, or I have bogus syntax.
>>
>> I am new to using SQL outside of the "drag-and-drop" Access method, so
>> this might be a silly question.
>>
>> If this can't be done I suppose I could add one value as a SELECT
>> statement, then try to locate that row in the table and do an UPDATE to
>> the other column (in this case, the cast column) where I just inserted
>> the data.
>>
>> Thank you!
>> George R.
>>
>>
>>
>>
>>
>>
>
>
>

-- 
www.andforthelamb.org
www.outreachhockey.org

They deem me mad for I will not sell my days for gold; I deem them mad for they 
think my days have a price.


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to