Sunday, December 2, 2012
w3schools.com
select * from Accounts, Branch
where Accounts.BranchId = Branch.BranchID
SELECT Accounts.AccountID, Accounts.CustomerID, Accounts.BranchID, Accounts.Balance
FROM Branch INNER JOIN Accounts ON Branch.BranchID = Accounts.BranchID
WHERE (((Accounts.BranchID)="b50"))
ORDER BY Accounts.AccountID;
http://eniac.cs.qc.edu/~svitak/cs12/
quiz next week, based on multiple choice from
Access ch 1, 2, 3
SELECT Agents.FirstName, Agents.LastName, Properties.DateListed, Properties.ListPrice, Properties.SalePrice, Properties.SqFeet, Properties.Sold, [ListPrice]/[Beds] AS PricePerBR, ListPrice / (Beds + Baths) As PricePerRoom
FROM Agents INNER JOIN Properties ON Agents.AgentID = Properties.AgentID
WHERE (((Properties.Sold)=No));
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment