Have three databases, respectively is: the city of database, database, factory product database,

1, the city database has two fields

ID1_name - & gt; Province name
ID2_name - & gt; City name

2, the factory database only one field (factory name)
ID3_name - & gt; The factory name

3, the product database has two fields
Field name for the factory, 1 to 2 product name

IDX_name -- -- -- -- -- & gt; The factory name
Product_name - & gt; Product name

Excuse me:

Enter the province and city name and name of the factory, how to found in the database] [products all meet the conditions of record?

CodePudding user response:

For example, is library name. The name of the table
To list the query,
Of course, you can also put cities and factories respectively query into the program, and then in to product query