How to apply Containstable 4 two join table?
Posted
by jaykanth
on Stack Overflow
See other posts from Stack Overflow
or by jaykanth
Published on 2010-06-16T08:19:07Z
Indexed on
2010/06/16
8:22 UTC
Read the original article
Hit count: 260
sql
|sql-server-2008
product table pid modelnumber 1 a 2 b 3 c
ProductTransation pid name description... 1 ball ball 2 bat cricket bat
i create fullText for Modelnumber in product table. " for name & Description in productTrasaction table.
Now i want to join this table if i search through modelnumber or name result should be
pid name modelnumber 1 ball a
© Stack Overflow or respective owner