WHERE a = bcd

[LinnCounty]

I don't have time to search anymore. I can not find the proper keyword.

I need help with a JOIN or a WHERE expression.

TABLE1 contains CASE_NUMBER
TABLE2 contains DEPT,YEAR,NUMBER

CASE_NUMBER is DEPTyearNUMBER

How do I format a JOIN or WHERE statement to use this info?

 

[SkipVought]

Hi,

select TABLE1.*, TABLE2.*
From TABLE1, TABLE2
Where CASE_NUMBER = 'DEPT||YEAR||NUMBER'

or whatever concatenation operator your version of SQL recognizes.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[LinnCounty]

Ah.. the pipe dream perfect. I will try it out. THANK YOU!!!

 

[LinnCounty]

I'm using DB2 and did not have enough luck with this as I'd hoped. It looks like the fields in TABLE2 are just not meant to be joined like this. I have found a work around that gets me where I need to go.

Thanks for your help, maybe I'll get to use this in the future.