Relational Databases - An Example - Search

This page follows on from importing data page.

We now need to add 2 additional tables, purchase and company:

4 tables

We also need to have more powerful ways to search these tables.

I experimented with creating a query by I cannot find anything useful yet:

query 1

 

query 2

 

query 3

 

query 4

Other sections are:

Data:


metadata block
see also:

 

 

Correspondence about this page

Book Shop - Further reading.

Where I can, I have put links to Amazon for books that are relevant to the subject, click on the appropriate country flag to get more details of the book or to buy it from them.

 

Commercial Software Shop

Where I can, I have put links to Amazon for commercial software, not directly related to this site, but related to the subject being discussed, click on the appropriate country flag to get more details of the software or to buy it from them.

 

This site may have errors. Don't use for critical systems.

Copyright (c) 1998-2017 Martin John Baker - All rights reserved - privacy policy.