07-05-2011, 05:56 AM
Brother u Must write This code like this in order to create the view
create view [view_name] as SELECT [product-name],[category-name] FROM product, category
WHERE product.[category-ID] = category.[category-ID]
create view [view_name] as SELECT [product-name],[category-name] FROM product, category
WHERE product.[category-ID] = category.[category-ID]
