Urgent

i want to execut two queries from unrelated table in single query.



is it posiible the below logic

"select PRODUCT_NAME from Products and

select Divisionname from Division "



i want to store colums of two different tables in single table



thanks in advance

narasim

and the results should go into a single field, or mutliple fields?

you'll need to do it in two queries, an example of one below

Insert into [your table] ([your field name]) VALUES ((select PRODUCT_NAME from Products))

Create your two queries,



SELECT tblProduct.ProductNameID, tblProduct.ProductName

FROM tblProduct;



SELECT tblDivision.DivisionNameID, tblDivision.DivisionName

FROM tblDivision;



Create a new table with the relevant fields, tblNewTable



Create an append query from the first and second queries.



INSERT INTO tblNewTable ( ProductName, DivisionName )

SELECT qryProduct.ProductName, qryDivision.DivisionName

FROM qryProduct INNER JOIN qryDivision ON qryProduct.ProductNameID=qryDivision.DivisionNameI D;

If there is no order to combination of the 2 fields and no relationship, I believe you can just put talbles into 1 query, drop down both fields from each table, and make it append query to the 1 table.