ذخیره نتیجه یک دستور سلکت در داخل یک تیبل

[saeed_vbvb]

با سلام خدمت همگی دوستان
من میخوام نتیجه این کوری داخل یک یک تیبل ذخیره بشه ولی چه جوری؟


"
SELECT dinner_tbl.meat_name, dinner_tbl.meat_price, Sum(data_TBL.dinner_Value) AS valus, Sum(data_TBL.dinner_Value*dinner_tbl.meat_price) AS total FROM dinner_tbl INNER JOIN data_TBL ON dinner_tbl.meat_ID = data_TBL.meat_ID WHERE ((data_TBL.Date1)>= '" & TempDateS & "' And (data_TBL.Date1)<='" & TempDateE & "') and meat_type='ÕÈÍÇäå' GROUP BY dinner_tbl.meat_name, dinner_tbl.meat_price" & _
" UNION SELECT dinner_tbl.meat_name, dinner_tbl.meat_price, Sum(data_TBL.dinner_Value) AS valus, Sum(data_TBL.dinner_Value*dinner_tbl.meat_price) AS total FROM dinner_tbl INNER JOIN data_TBL ON dinner_tbl.meat_ID = data_TBL.meat_ID WHERE ((data_TBL.Date1)>= '" & TempDateS & "' And (data_TBL.Date1)<='" & TempDateE & "') and meat_type='äÇåÇÑ' GROUP BY dinner_tbl.meat_name, dinner_tbl.meat_price"

من با این کوری این کار میکردم


"SELECT dinner_tbl.meat_name, dinner_tbl.meat_price, Sum(data_TBL.dinner_Value) AS valus, Sum(data_TBL.dinner_Value*dinner_tbl.meat_price) AS total INTO temp FROM dinner_tbl INNER JOIN data_TBL ON dinner_tbl.meat_ID = data_TBL.meat_ID WHERE ((data_TBL.Date1)>= '" & TempDateS & "' And (data_TBL.Date1)<='" & TempDateE & "') GROUP BY dinner_tbl.meat_name, dinner_tbl.meat_price"

ممنون منتظر جواب شما هستم

[esmaeily-hosein]

با استفاده از select into
select * into tablename '#tablename for temp table
from
Production.Product