Request Correct SQL Syntax for joining two table

[smfayayz]

Hi

I am new to this forum and have question, can someone help me with right sql syntax.

I am joining two table where one table has numeric field 5 digit long and other is numeric 3 digit long.

Like: Library.table1.cyy = Library.table2.cyymm(1:3)

Visually see concept below of above code.
Like2: Library.table1.108 = Library.table2.10805(1:3)


what is a correct sql syntax.

Please help.

Thanks
Syed

Thanks
Syed.

 

[guelphdad]

look in the manual for use of LEFT()

 

[smfayayz]

There is no such thing in Manual defined as LEFT()

I will more search for Left may be on Internet..


Thanks
Syed.

 

[smfayayz]

Hi gulphdad

OK, I found it but that is for VarChar what about Integer or Numeric value.

I like to use it in join statement.

Thanks
Syed.

 

[tsuji]

>Like: Library.table1.cyy = Library.table2.cyymm(1:3)
[tt]Library.table1.cyy = Library.table2.cyymm div 100[/tt]