about site search

[jason_mf]

I've never done search-related. the search-content contains: musics,pictures,peoples etc. so I have a few questions. Search content from multiple tables and multiple Fields. I do full-text indexing of these fields. If I need to create a view that contains these fields? then I write sql "select" from this view. is right? I hope someone can give a guiding learning resources. Thanks.