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 Mike Lewis 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
0
0
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
354
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
227
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
283
BobSuruncle
BobSuruncle
Cpreston
  • Question
Seconds to minutes 2
Replies
5
Views
382
Chris Miller
Chris Miller
WomanPro
  • Locked
  • Question
Insert into query adds records to unreadable format, how do I change that? 1
Replies
5
Views
207
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top