|
|
Posted by Ed Murphy on 11/04/79 11:58
muzili@gmail.com wrote:
> 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?
You shouldn't do that. Why do you want to? What do you intend to
do if a member belongs to four or more categories?
Navigation:
[Reply to this message]
|