search multiple fields from two tables with one string
Posted on 2004-04-16
I'm trying to query two tables
used_cons & used_ag
for these fields
used_cons.MAKE, used_cons.MODEL, used_cons.DESCRIPTION,
used_ag.MAKE, used_ag.MODEL, used_ag.DESCRIPTION
that match a string passed through a url
Please recommend if I should do as above or...
I'm not sure if my url's are formatted properly. Should I search the exact string or firstword and/or secondword. I don't want douplicate results.