Results 1 to 8 of 8
Jan 21, 2010, 22:28 #1
- Join Date
- Aug 2009
- 0 Post(s)
- 0 Thread(s)
Two "From" Clauses in Select Statement-help
Is it possible to write two "from" clauses in a select statement, so that the search queries two tables? Or, do I need a join statement in here?
The submitted form in html has two text input boxes for keywords. I want each input box to search different tables.
"SELECT * FROM table_1 WHERE MATCH(column) AGAINST("word_1" IN BOOLEAN MODE) AND SELECT * FROM table_2 WHERE MATCH(column) AGAINST("word_2" IN BOOLEAN MODE)"