a simple select like this (if you know the order of tables):
SELECT (tableb.valuea + " " + tableb.valueb + " " + tablea.valuec) FROM `tableb`, `tablea` where (tableb.valuea + " " + tableb.valueb + " " + tablea.valuec) = "XXXX XXX XX"
N. Kavithashree wrote:
hello i hv one query as explained below : Table FIRST contains This is What is this how whom color white Table SECOND contains WHOM THIS IS WHAT WHITE AND BLACK i want the result as This is what is this what whom white WHITE AND BLACK i want a query which searches both table for exact match as well as partly match. Even if part of the string matches it should get displayed in the result. thanks in advance kavitha
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
