How can I create a view in mysql -

The SQL looks like this:

  select * From A to AID (A. Select group by id, where b.date & gt; '2015-01-01') group;  

b.data> '2015-01-01' is a dynamic situation.

You can not use a subkey in a view, but you are included in the tables for your requirement Can be:

  Create my_view as a view. A inner inner in b to aid = b Where Baidu & gt; '2015-01-01' Group by AID;