can I create an insert query using both Select and literal values

[rambleon]

Hi
I'd like to do the following
Insert into TableA(Fld1, Fld2, Fld3)
Values(Select Fld1 from TableB, 123, "XYZ")

Fld1 & Fld2 in TableA are the primary index

How can I combine a Select statement and literal values
in 1 insert.

Thanks for any help

Rambleon

 

[KenReay]

Hi

Insert into TableA
Select Fld1, "123" As Fld2,"XYZ" As Fld3 from TableB;


Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK