Information Management (R)
moosha
db.accdb| Category_ID | Type |
|---|---|
| 1 | New |
| 2 | Existing |
| Customer_ID | CName | CAdderss | CPost-code | CDistance | CTelephone | Product_ID | CCategory |
|---|---|---|---|---|---|---|---|
| 1 | AA Alarms | 108 spring grove | TW4 5NP | 2 | 02078989571 | 1 | 1 |
| 2 | A cc tv | 111 spring grove | TW9 5NP | 10 | 02089765129 | 2 | 2 |
| Product_ID | PName | PType |
|---|---|---|
| 1 | Alarms | Security |
| 2 | Cameras | Security |
SELECT [Category].[Customer_ID]
FROM Category;
SELECT [Products].[Product_ID]
FROM Products;
SELECT [Category].[Customer_ID]
FROM Category;
SELECT [Products].[Product_ID]
FROM Products;
SELECT [Category].[Customer_ID]
FROM Category;
SELECT [Products].[Product_ID]
FROM Products;
SELECT DISTINCTROW *
FROM Customer;
SELECT DISTINCTROW *
FROM Products;
SELECT Customer.[Customer_ID], Customer.[CName], Customer.[CAdderss], Customer.[CPost-code], Customer.[CDistance], Customer.[CTelephone], Customer.[Product_ID], Customer.[CCategory]
FROM Customer
WHERE (((Customer.[CDistance])>=5));
SELECT Customer.[Customer_ID], Customer.[CName], Customer.[CAdderss], Customer.[CPost-code], Customer.[CDistance], Customer.[CTelephone], Customer.[Product_ID], Customer.[CCategory]
FROM Customer
WHERE (((Customer.[CDistance])<=5));
SELECT Customer.Customer_ID, Customer.CName, Customer.CAdderss, Customer.[CPost-code], Customer.CDistance, Customer.CTelephone, Category.Type
FROM Category INNER JOIN Customer ON Category.Category_ID=Customer.CCategory
WHERE (((Category.Type)="New"));
