Click here to Skip to main content
15,880,134 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to send an invitation mail in c# to a client Pin
Sandeep Mewara7-Jun-12 20:04
mveSandeep Mewara7-Jun-12 20:04 
AnswerRe: How to send an invitation mail in c# to a client Pin
vvashishta10-Jun-12 19:11
vvashishta10-Jun-12 19:11 
QuestionSQL Server CLR Parameter Types Pin
cjb1106-Jun-12 4:32
cjb1106-Jun-12 4:32 
AnswerRe: SQL Server CLR Parameter Types Pin
PIEBALDconsult6-Jun-12 4:58
mvePIEBALDconsult6-Jun-12 4:58 
QuestionOR in a JOIN Pin
PIEBALDconsult5-Jun-12 13:51
mvePIEBALDconsult5-Jun-12 13:51 
AnswerRe: OR in a JOIN Pin
Paul Conrad5-Jun-12 14:03
professionalPaul Conrad5-Jun-12 14:03 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult5-Jun-12 14:26
mvePIEBALDconsult5-Jun-12 14:26 
AnswerRe: OR in a JOIN Pin
Luc Pattyn5-Jun-12 16:27
sitebuilderLuc Pattyn5-Jun-12 16:27 
Ah, I didn't know logic operators were allowed in the ON clause, but as they are, why not just exploit them to the fullest:

SELECT *
FROM TableA A 
INNER JOIN TableB B
ON A.Field1=B.Field1
OR (A.Field1<>B.Field1 AND A.Field2=B.Field2)


Maybe now is the time for a Java | [Coffee] ?
Luc Pattyn [My Articles] Nil Volentibus Arduum

GeneralRe: OR in a JOIN Pin
Paul Conrad5-Jun-12 17:00
professionalPaul Conrad5-Jun-12 17:00 
AnswerRe: OR in a JOIN Pin
Luc Pattyn5-Jun-12 17:31
sitebuilderLuc Pattyn5-Jun-12 17:31 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult5-Jun-12 18:10
mvePIEBALDconsult5-Jun-12 18:10 
GeneralRe: OR in a JOIN Pin
Paul Conrad5-Jun-12 19:15
professionalPaul Conrad5-Jun-12 19:15 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult6-Jun-12 3:46
mvePIEBALDconsult6-Jun-12 3:46 
GeneralRe: OR in a JOIN Pin
Paul Conrad6-Jun-12 7:38
professionalPaul Conrad6-Jun-12 7:38 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult6-Jun-12 9:12
mvePIEBALDconsult6-Jun-12 9:12 
GeneralRe: OR in a JOIN Pin
Paul Conrad6-Jun-12 9:16
professionalPaul Conrad6-Jun-12 9:16 
AnswerRe: OR in a JOIN Pin
pmpdesign5-Jun-12 19:34
pmpdesign5-Jun-12 19:34 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult6-Jun-12 3:24
mvePIEBALDconsult6-Jun-12 3:24 
AnswerRe: OR in a JOIN Pin
Bernhard Hiller5-Jun-12 21:09
Bernhard Hiller5-Jun-12 21:09 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult6-Jun-12 3:26
mvePIEBALDconsult6-Jun-12 3:26 
AnswerRe: OR in a JOIN Pin
Chris Meech6-Jun-12 4:30
Chris Meech6-Jun-12 4:30 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult6-Jun-12 5:55
mvePIEBALDconsult6-Jun-12 5:55 
GeneralRe: OR in a JOIN Pin
Chris Meech6-Jun-12 6:56
Chris Meech6-Jun-12 6:56 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult6-Jun-12 9:10
mvePIEBALDconsult6-Jun-12 9:10 
GeneralRe: OR in a JOIN Pin
Chris Meech6-Jun-12 10:07
Chris Meech6-Jun-12 10:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.