Thread: How to COUNT records in UNION?
View Single Post
  #2 (permalink)  
Old 07-01-2007, 06:53 PM
Unregistered
 
Posts: n/a
Default ANY answer. Re: How to COUNT records in UNION?
select count(*) from
(SELECT fld1 FROM tbl1 WHERE [expression] UNION SELECT fld1 FROM tbl2 WHERE [expression])
Reply With Quote