Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Duplicate pkey in Union query

Status
Not open for further replies.
millrat

millrat

Technical User
Dec 23, 2003
98
US
Hi all,

If I have these fields in a table

pkey fld1 fld2 fld3
1 A B C

How to create union query to give

fld1 fld2
1 A
1 B
1 C

Cheers,
millrat
 
Sort by date Sort by votes
How about:
Select pkey, fld1 From tblTable
Union Select pkey, fld2 From tblTable
Union Select pkey, fld3 From tblTable
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
282
OzFoxy
OzFoxy
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
1K
TheresAlwaysAWay
TheresAlwaysAWay
C
  • Question
Query expression negative to a 0
Replies
6
Views
389
dhookom
dhookom
serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
887
strongm
strongm
breezett93
  • Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
5
Views
188
Chriss Miller
C

Part and Inventory Search

Sponsor

Back
Top