DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

Joining two tables in VB 6

Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site

•

Join Date: Jul 2007

Posts: 300

Reputation: jireh is an unknown quantity at this point

Solved Threads: 42

jireh

Offline

Posting Whiz

Re: Joining two tables in VB 6

#11

Sep 28th, 2007

here's a sample:

 Help with Code Tags 
 Visual Basic 4 / 5 / 6 Syntax (Toggle Plain Text) 
str = "select [Book File].Author,[Book File].BookTitle,Return,Penalty,[Transaction File].StudentNumber from ([Transaction Table] left join [Book File] on [Transaction Table].AccessionNumber=[Book File].AccessionNumber left join [Student File] on [Transaction Table].StudentNumber=[Student File].StudentNumber where return=1 and penalty<>0 and BorrowDate>='" & Format(dtpDateFrom, vbShortDate) & "' and BorrowDate<='" & Format(dtpDateTo, vbShortDate) & "'"
str = "select [Book File].Author,[Book File].BookTitle,Return,Penalty,[Transaction File].StudentNumber from ([Transaction Table] left join [Book File] on [Transaction Table].AccessionNumber=[Book File].AccessionNumber left join [Student File] on [Transaction Table].StudentNumber=[Student File].StudentNumber where return=1 and penalty<>0 and BorrowDate>='" & Format(dtpDateFrom, vbShortDate) & "' and BorrowDate<='" & Format(dtpDateTo, vbShortDate) & "'"