|
-
Oct 18th, 2007, 09:12 AM
#1
Thread Starter
Fanatic Member
Can anyone help me here INNER JOIN error..
what's lacking with my code..?
please help me...
Dim com As New OleDbCommand("SELECT 'Sheet1'.'RsoNo', 'Sheet1'.'Customer', 'Sheet3'.'ItemCode', 'Sheet3'.'ItemDescription', " & _
"'Sheet3'.'Source','Sheet3'.'MOQ','Sheet3'.'QuantityRequired','Sheet3'.'Remarks','Sheet1'.'ZeroStock ', " & _
"'Sheet1'.'NewProduct','Sheet1'.'ProjectForecast','Sheet1'.'WithMotherPO','Sheet1'.'Others', " & _
"'Sheet1'.'RequestedBy', 'Sheet1'.'NotedBy', 'Sheet1'.'RecievedBy' " & _
"FROM ('Sheet1' 'Sheet1' " & _
"INNER JOIN 'Sheet3' 'Sheet3' ON " & _
"'Sheet1'.'RsoNo'='Sheet3'.'RsoNo' where 'rsono'='" & useprintrsono & "'")
com.CommandType = CommandType.Text '' command type
com.Connection = cn '' give connection to command
Dim adp As New OleDbDataAdapter '' declare adapter
adp.SelectCommand = com '' select command for adpapter to work on
Dim ds As New DataSet '' delcare dataset
adp.Fill(ds, "sheet3")
and what table should i put here since it is combination of two tables... " adp.Fill(ds, "sheet3") "
if long statement what it is look like..?
please help me...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|