Posted by dhek on 02/22/07 16:40

>> I have a very simple issue: for simplicity lets say I have 2 tables, A
>> and
>> B.
>> - Table A contains 5 fields. Amongst these there is a 'id'-field
>> which
>> is but a reference to table B.
>> - Table B contains 2 fields: 'id' and 'text'
>>
>> In order to post data to table A I thus (from a known text value that
>> should
>> match 1 value in B.text) have to get the value of B.text before
>> performing
>> the UPDATE/INSERT statement.
>>
>> How is this possible?
>>
>> I would have thought something like
>>
>> INSERT INTO A (val1, val2, val3, ID, val4)
>> VALUES ('x1','x2','x3', SELECT id FROM B WHERE [SOME TEXT VALUE] =
>> B.text,
>> 'x4')
>>
>> however this is not possible, so I'm lost - not experienced in the arts
>> of
>> SQL:-)
>>
>> Hope someone can help.
>>
>> Best Regards,
>> Daniel
>
> Try something more like this:
>
> INSERT INTO ATable(val1, val2, val3, ID, val4)
> SELECT 'x1', 'x2', 'x3', b.id, 'x4'
> FROM BTable b
> WHERE b.Text = ['Your Text Here']

But this is not possible since table B only contains 2 fields (id, and text)
or am I misunderstandig u?

• Next in forum: Re: sum a table within a table
• Prev in forum: Re: SQL statement - INSERT INTO and SELECT
• Thread view: Re: SQL statement - INSERT INTO and SELECT

[Reply to this message]