I need to fulltext search these two tables. The ARTICLE_ID is the common key for both. The CONTENT in articles is empty when the article is a galery, so in that case for this ARTICLE_ID the content is stored in galeries table and can have multiple instances with the same ARTICLE_ID.
The search keyword may be contained in TITLE,DESCRIPTION and CONTENT fields.
I'm stack with this and I can't think a valid query.
But the two tables is related in some way with the ARTICLE_ID and the TILE,DESCRIPTION fields. The galeries query must contain TITLE and DESCRIPTION fields for the search to work..At least i can't think of an other way to search in galeries table and have result including these two fields in it.And in adition to this the two tables have different number of fields.
Sorry for being so pester but i've been thinking of this for more that 6 hours and my brain is ready to collapse.