Answer for:

SQL Statement in VB6 Code

Message 6 of 12

View entire thread
0 Votes

Assuming the link between the two tables tblInfo and tblPayments is fldSuit, you have to use this field to join the two tables on the FROM clause as:

From tblInfo inner join tblPayments on tblInfo.fldSuit = tblPayments.fldSuit

It's only that I am not sure what error message you are getting but try this.

Hope it helps.