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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Request Correct SQL Syntax for joining two table
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. -
Request Correct SQL Syntax for joining two table
There is no such thing in Manual defined as LEFT() I will more search for Left may be on Internet.. Thanks Syed. -
-
Request Correct SQL Syntax for joining two table
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... -
dynamic query in a stored procedure
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.cyymm = Library.table2.cyy(1:3) what I mean is what is correct syntax for...
