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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to join two queries optionally?

Status
Not open for further replies.
SolvableJoker

SolvableJoker

Programmer
Sep 16, 2001
6
GB
Hello,

I've got two queries that I want to join if the second query returns data, otherwise I'd still like the rest of the report to produce an output.

Does anyone know how to do this?

I've scanned the help files to no avail [thumbsdown]

Cheers,

Matt
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
1K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
777
Andrzejek
Andrzejek
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
546
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
882
BobSuruncle
BobSuruncle
Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
1K
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top