|
Subject:
|
Views
|
|
Posted By:
|
prashar
|
Post Date:
|
12/12/2005 9:09:12 AM
|
S(S#, SNAME, STATUS, CITY) PRIMARY KEY (S#)
P(P#, PNAME, COLOR, WEIGHT, CITY)PRIMARY KEY (P#)
J( J#, JNAME) PRIMARY KEY (J#)
SPJ( S#, P#, J#, QTY) PRIMARY KEY (S#,P#,J#)
question. create a view consisting of supplier tuples for supliers that are located in London
Ans
create view vw_london
as
select * from s where city = 'london'
Is this right
|
|
Reply By:
|
jbenson001
|
Reply Date:
|
12/13/2005 1:10:40 AM
|
Test it and find out.
|
|
