Return multiple entries from a SELECT

[Belle19]

I need to return two rows for every row from a table. For instance, the table layout could be:

Cust_name Cust_Address Check_no
John 123 Main St. 1234
Jane 456 Eve St. 5678

My results that I am attempting to get back need to be as such:

John 123 Main St. 1234
John 123 Main St. 1234
Jane 456 Eve St. 5678
Jane 456 Eve St. 5678

Any ideas on a way to do this without complicating matters????

 

[r937]

select Cust_name, Cust_Address, Check_no
  from daTable
union all
select Cust_name, Cust_Address, Check_no
  from daTable

alternatively...

select Cust_name, Cust_Address, Check_no
  from daTable
cross
  join ( select 1 union select 937 ) as two

r937.com | rudy.ca

 

[gmmastros]

Select Fields...
From   Table 
       Cross Join 
         (
         Select 1 As DupNumber 
         union All 
         Select 2
         ) As A

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[Belle19]

Thanks for the responses!!!!

I tried this:

select check_number, customer_name, check_amount, fl_flag
from process_76
where fl_flag = '1'
union all
select check_number, customer_name, check_amount, fl_flag
from process_76
where fl_flag = '1'

It returns the rows that I need however is there anyway to group the rows together that are alike???

 

[SQLDenis]

add ORDER BY customer_name,check_number

at the end

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/