Posted by Utahduck on 02/22/07 16:10

On Feb 22, 8:57 am, "dhek" <d...@REMOVEvip.cybercity.dk> wrote:
> Hi,
>
> 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']

[Back to original message]