Re: Creating a view from a join

> I have two tables with quite a few fields and I want to create a view > into a limited join of the table. I have a query like: > >select * from person > inner join student on person.id=student.id > where person.dormant != 'Y'; > > The select works fine but when I try to use My

Creating a view from a join

I have two tables with quite a few fields and I want to create a view into a limited join of the table. I have a query like: select * from person inner join student on person.id=student.id where person.dormant != 'Y'; The select works fine but when I try to use MySQL Query Brows