how i full calm hunt opposing churned tables, sql server 2005


i have full calm catalog twin tables it.



tablea 4 columns (a1, a2, a3, a4) wich 3 indexed catalog, a2,a3,a4.
a1 primary key.



tableb 3 columns (b1, b2, b3, b4), twin indexed catalog, b3 b4. b1 pk table, b2 fk tablea.



i wish something like



select *, (fttablea.[rank] + fttableb.[rank]) total_rank 
from tablea
inner join tableb tablea.a1=tableb.b2
inner join freetexttable(tablea, (a2,a3,a4), 'search term') fttablea tablea.a1=fttablea.[key]
inner join freetexttable(tableb, (b3,b4), 'search term') fttableb tableb.11=fttableb.[key]


but does work...
i unparalleled list work, eg.



select *, (fttablea.[rank] + fttableb.[rank]) total_rank 
from tablea
inner join freetexttable(tablea, (a2,a3,a4), 'search term') fttablea tablea.a1=fttablea.[key]


but never some-more table.



could someone give an reason and/or instance stairs mandatory full-text hunt over churned tables.



Comments

Post a Comment

Popular posts from this blog

list macos calm editors formula editors

i searched found maudite's doubt text editors nonetheless windows. as have doubt guessed, i am perplexing out there any text/code editors mac besides i know of. i'll correct post consolidate editors listed. free textwrangler xcode mac vim aquamacs closer uncanny emacs jedit editra eclipse netbeans kod textmate2 - gpl brackets atom.io commercial textmate bbedit subethaedit coda sublime calm 2 smultron webstorm peppermint articles associated subject faceoff, best calm editor ever? maceditors.com, mac editors comforts compared thank everybody total suggestions.
Read more

how hibernate @any-related annotations?

could someone explain me any-related annotations ( @any , @anymetadef , @anymetadefs @manytoany ) work practice. i have tough awaiting any useful support (javadoc alone isn't unequivocally helpful) these. i have so distant collected somehow assent referencing summary extended classes. case, since there an @onetoany annotation? 'any' referring unparalleled 'any', churned 'any'? a short, receptive illustrating instance unequivocally many appreciated (doesn't have compile). edit: many i accept replies answers give credit where due, i found both smink's sakana's answers informative. since i can't accept several replies the answer , i unfortunately symbol conjunction answer.
Read more

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?

Image
hopefully settlement value thousand lines formula since i don't wish have frame down asp.net code, html, javascript, css yield an instance (but i'll supply i on ask someone doesn't contend "oh, i've seen before! try this...") [actually, i post formula css - bottom question]. here apportionment form page being displayed firefox: the blue boxes surrogate stylings <label> add-on orange lines surrogate border styles <div> tags (so i where extend break). <label> 's styled float: left <div 's right. addition, heir controls <div> also float:left definitely line adult tip <div> (since there taller controls multiline textboxes down below). the radio buttons generated an asp control, wrapped <span> - also floated left given heir <div> . here same apportionment shade rendered ie7: there few teenager digest differences, nonetheless large that's pulling me crazy additional white space beside <input> con...
Read more