Help with Insert query

[welshone]

How can I change this query into an insert query so the info. in Post gets copied into PostTitle ?


SELECT tblContractDetails.PostTitle, tblPost.Post,
tblContractDetails.ContractID
FROM tblContractDetails LEFT OUTER JOIN
tblPost ON tblContractDetails.PostID = tblPost.PostID
WHERE (tblContractDetails.PostTitle IS NULL) OR
(tblContractDetails.PostTitle = ' ')

cheers.
Jamie

 

[redlam]

Hi.
Give this a try:

INSERT INTO tblPostTitle
(PostTitle, Post, ContractID)
SELECT tblContractDetails.PostTitle, tblPost.Post,
tblContractDetails.ContractID
FROM tblContractDetails LEFT OUTER JOIN
tblPost ON tblContractDetails.PostID = tblPost.PostID
WHERE (tblContractDetails.PostTitle IS NULL) OR
(tblContractDetails.PostTitle = ' ')