First off I hope this is the correct area to post this question as I wouldn't want to be cluttering the forum.
I was wondering if anybody could help regarding a MySql statement, this particular query has been driving me crazy for the past two days. I'm trying to include a variable within the WHERE statement allowing the user to edit what is searched for.
Here is a snippet of my code:
Code: Select all
put "SELECT tbl_one.*,tbl_two.mpn, tbl_two.cost_price, tbl_two.list_price FROM tbl_one,tbl_two " & \
"WHERE tbl_one.mpn = tbl_two.mpn" & vUserInput & "" into tQuery
I hope this makes sense to someone, I feel that this is somewhat easy and I'm completely overlooking it and or being an idiot.
Any help would be greatly appreciated.
Gary