Web Development

Ask something
Question Locked

sql query

0 helpful
2 replies

by arshadalimalik

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Dim strSuit As String
strSuit = " steel 1/3' "
strQuery = "SELECT tblInfo.fldSuit, tblPayments.fldSuit, tblInfo.fldRCR, tblPayments.fldPDate, tblPayments.fldPaid, tblPayments.fldBalance, tblPayments.fldCashier, tblPayments.fldRecNum, tblPayments.fldVchNum
FROM tblInfo INNER JOIN tblPayments ON tblInfo.fldSuit = tblPayments.fldSuit
WHERE tblPayments.fldSuit='" & strSuit & "'"

2 replies

by tony hopkinson

I know what mine is what possessed you to prefix all your column names with fld. I don't get it....

This discussion is closed to new replies.