need a sql query in SQL Server

[PeriyurParthi]

thanks for your immdeiate response, i think you have not understood my problem. let me explain in detail.

i have 3 master tables called m1,m2,m3 and i have a trasaction table called t1. iam inserting datas THRU VB useing insert query.

INSERT INTO T1 VALUES("CODE", "NAME",PRODUCT CODE FROM M1 WHERE PRODUCTNAME="TEST", CATEGORY CODE FROM M2 WHERE CATEGORYNAME="TEST1" )

FOR THE ABOVE PROBLEM I NEED SQL QUERY
HOPE U HAVE GOT
THANKS
PARTHI

 

[peter3244]

I think what you need is something like this...

INSERT INTO T1 VALUES(CODE, NAME,PRODUCT CODE, CATEGORY CODE)
SELECT CODE,
NAME,
[PRODUCT CODE],
(SELECT [CATEGORY CODE] FROM M2 WHERE
CATERGORYNAME='TEST1')
FROM M1,
WHERE PRODUCTNAME='TEST'

 

[harmmeijer]

INSERT INTO T1
(fieldCode,fieldName,
fieldProductCode, fieldCategoryCode)
VALUES
(
"CODE",
"NAME",
(select [PRODUCT CODE] FROM M1 WHERE PRODUCTNAME="TEST&quot,
(select [CATEGORY CODE] FROM M2 WHERE CATEGORYNAME="TEST1&quot
)

Does this work for you?

 

[PeriyurParthi]

thanks for all your replies, i think u havent understood my proble, let me explain once again
i have 1 transaction table and 2 or 3 master tables, i need insert code in trasaction table from master table, hope u have understood,
thanks
parthi

 

[SQLBill]

Maybe you didn't make your problem clear enough....which of these are you are asking for?

1.
You have a table T1 with the columns CODE, NAME, PRODUCT CODE, CATEGORY CODE
You want to put the product code from table M1 into the T1.PRODUCT CODE and the category code from table M2 into T1.CATEGORY CODE

or

2.
You have a table T1 with the columns CODE, NAME)
You want to put the product code from table M1 into the T1.CODE column and the category code from table M2 into the T1.NAME column

#1 is what everyone is giving you the solution to.

SQLBill