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

if stmt within query?

Status
Not open for further replies.
ecannizzo

ecannizzo

Programmer
Sep 19, 2000
213
US
Can I do something like this within my query?

if h.notes = "Issue" then
left outer join ISSUES i on h.record_id = i.id
else
left outer join ISSUES2 i on h.record_id = i.id
end;

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

Similar threads

kernal
  • Locked
  • Question
If there is a Fee on Class Level then that fee overrides Fee on Course Level 1
Replies
3
Views
104
kernal
kernal
kernal
  • Locked
  • Question
If Day of the Week='Y' (i.e. Mon='Y') and between a Start Date and End Date then Count #of Days 1
Replies
1
Views
96
Beilstwh
Beilstwh
kernal
  • Locked
  • Question
CONCAT DayofWeek Fields if Field Value =Y 3
Replies
4
Views
99
kernal
kernal
ssmith999
  • Locked
  • Question
Query help w/ fiscal calendar query
Replies
1
Views
81
johnherman
johnherman
rk68
  • Locked
  • Question
auto execute procedure/query on record insert
Replies
13
Views
108
rk68
rk68

Part and Inventory Search

Sponsor

Back
Top