DevOps Solutions
Pages
Home
ASP.NET
Cystal Report
Mysql
PHP
VB.NET
VB6
About Me
Tuesday, July 5, 2011
SQL INNER JOIN
strSQL = "SELECT tbl_stud.id, tbl_stud.name, tbl_stud.address, tbl_course.course FROM tbl_stud INNER JOIN tbl_course ON tbl_stud.id = tbl_course.id"
DataGridView1.DataSource = objc.GetDataTable(strSQL, CommandType.Text)
SQL INNER JOIN Syntax
SELECT column_name(s)
FROM table_name1
INNER JOIN table_name2
ON table_name1.column_name=table_name2.column_name
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment