Posted by muzili on 11/01/10 11:58

Hi All,
I have two tables, one is about member infomations, the other is the
catergories
member_info(id,name,email,phone)
member_categories(id,category)

how can create a view like this (id, name, category1, category2,
category3) with high performance?

Thanks in advance.
Joshua

• Next in forum: Re: howto use the query results as view column?
• Prev in forum: Re: sql server i/o bottle neck ?
• Thread view: howto use the query results as view column?

[Reply to this message]