gistfile1.txt

INSERT INTO postings (id,cb,partner_id,post_date,posting_type,status,doc_type,doc_no,attachment_no)
						(
							SELECT 
									a.posting_id as id,
									a.cb as cb,
									a.partner_id as partner_id,
                  c.date as date,
									"Purchases" as posting_type,
                  "Posted" as status,
                  "RR" as doc_type,
									a.doc_no as doc_no,
									c.id as attachment_no
							from gl_entries as a
							LEFT JOIN receive_headers as b on b.id = a.doc_no
							LEFT JOIN receive_post_details as c on c.rr_id = b.id
							where a.doc_type = "RR" and a.doc_no = 20283 and b.status in ("Approved","Printed")
							limit 1
						)