Go4Expert - View Single Post - Using a Query to split 1 record in to 3 records

apr pillai

Create a UNION Query with the following sample SQL:

Code:

SELECT Table1.Field1 FROM Table1
UNION Table1.Field2 FROM Table1
UNION Table1.Field3 FROM Table1

apr pillai Go4Expert Member
21Feb2011,14:00
	Create a UNION Query with the following sample SQL: Code: SELECT Table1.Field1 FROM Table1 UNION Table1.Field2 FROM Table1 UNION Table1.Field3 FROM Table1