Member Avatar for Pgmer

Hi All,

SELECT
            'Name A ' as Column0, 
		Some column  as Column2,		
	      FROM  MyTable
WHERE 	my condition

UNION 

SELECT 
	       'Name  B' as Column0, 
		Some other column  as Column2,		
	      FROM  MyTable
WHERE 	my condition

I want to concatenate the rowNumber with column0 any idea how to do that?

Thanks & Regards,
Vadiraj

  • 2 Contributors
  • 2 Replies
  • 75 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Pgmer

Recommended Answers

All 2 Replies

Member Avatar for anuj6928

union works only when both the tables havin same structures

Member Avatar for Pgmer

Hi Anuj.. Thanks..
I found the sollution for my problem.
:)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.