SQL syntax

[WP]

Hope someone can help with this.

Struggling with SQL code to join two tables.

Ok,

Table 1 has key fields SecurityCode(7A),SubCode(3A),Exchange(3 numeric)
Table 2 has key fields SecurityCode(7 numeric),SubCode(3 numeric),Exchange(3 numeric)

How can these tables be joined ?



Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch

 

[3587]

Are you looking to join on all three of these tables? If yes, is the data in SecuityCode table 1 and SecuityCode table 2 the same? If yes, then change the data types to match. If not then you can not join on these fields anyway.

 

[WP]

Ye, that's what I thought.

I can't change the data type as the table are remote linked DB2 tables.

Oh, well there is nothing I can do about poor design of mainframe tables.

Thanks for the reply anyways.

Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out

http://www.deepturtle.ch