<div>
<div class="content wysiwyg-content">
I have 2 tables, one contains orders one contains items,<br />
in items I have a key &nbsp;SUPPLIER &nbsp;in &nbsp;orders I have key ITEMNUMBER and CUSTOMERID<br />
<br />
so every record in items has the keys &nbsp;ITEMNUMBER and SUPPLIER active<br />
and every record in orders has the keys &nbsp;ITEMNUMBER and CUSTOMERID active<br />
<br />
my needed query is to get in one call as sample<br />
return all records from orders based on &nbsp;key &nbsp;'SUPPLIER= &nbsp; 'SONY' in items, &nbsp; <br />
and only for CUSTOMERID= &nbsp;'JACK'<br />
<br />
How to get this from the tables in one call?<br />
<br />
&nbsp; &nbsp; 
</div>
</div>


I have 2 tables, one contains orders one contains items,
in items I have a key  SUPPLIER  in  orders I have key ITEMNUMBER and CUSTOMERID

so every record in items has the keys  ITEMNUMBER and SUPPLIER active
and every record in orders has the keys  ITEMNUMBER and CUSTOMERID active

my needed query is to get in one call as sample
return all records from orders based on  key  'SUPPLIER=   'SONY' in items,   
and only for CUSTOMERID=  'JACK'

How to get this from the tables in one call?

    

WHAT IS SYNTAX FOR A SUBQUERY IN PERVASIVE SQL 2000

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.