Filtering Table Records from a view
Posted on 2007-11-19
I have two tables in a SQL SERVER 2005 View. They look like this:
A , 5.3
I am trying to create a view that sorts out rows in Table1 based on Table2. Table2 will always have some products with a weight of 0 (It could be any products in the range). I want to sort out all of the product records in Table1 that have a 0 weight in Table2.
I want the view to look like this:
I have been trying to do this by joining the tables in a view and just canÃƒÂ¢Ã‚Â€Ã‚Â™t quite get these resultsÃƒÂ¢Ã‚Â€Ã‚Â¦
Does anyone know how to do this??