UNION without DISTINCT

Hi guys,

Is there a away to run a Union query which won't automatically DISTINCT the results?

Cheers!
LVL 4
Cyber-DrugsAsked:
Who is Participating?
 
TimCotteeConnect With a Mentor Commented:
Hi Cyber-Drugs,

Select f1,f2 From a
UNION ALL
Select F1,F2 From B

Tim Cottee
0
 
Cyber-DrugsAuthor Commented:
Cheers TimCottee!
0
All Courses

From novice to tech pro — start learning today.