Filter column in one table by a column in another table
I have 2 tables in one I have only column of orderId containing all the orders from many restaurant and I want to filter it by the restaurant, I have other table where I have the restid and the orderId.
The two tables should be automatically associated by the common column orderid. When a user selects a restaurant from a filter pane, the list of orderid will be automatically filtered to those associated with the restaurant.
