<div>
in this case, the query should only select custid 101 and 103 as one of the orderid (7408) for custid 102 is not present in tablel B.
</div>


in this case, the query should only select custid 101 and 103 as one of the orderid (7408) for custid 102 is not present in tablel B.

IT Consultant

gvamsimba

<div>
Fantastic Ste5an. it worked like a charm .<br />
<br />
Many Thanks
</div>


Fantastic Ste5an. it worked like a charm .

Many Thanks

<div>
<div class="content wysiwyg-content">
Table A<br />
<br />
&nbsp; &nbsp;custid &nbsp; orderid<br />
&nbsp; &nbsp; &nbsp;101 &nbsp; &nbsp; &nbsp;5418<br />
&nbsp; &nbsp; &nbsp;102 &nbsp; &nbsp; &nbsp;7408<br />
&nbsp; &nbsp; &nbsp;102 &nbsp; &nbsp; &nbsp;5408<br />
&nbsp; &nbsp; &nbsp;103 &nbsp; &nbsp; &nbsp;9547<br />
&nbsp; <br />
<br />
&nbsp;Table B<br />
<br />
Orderid<br />
5418<br />
9547<br />
5408<br />
<br />
I have 2 tables. From table A I only need to select those custid where all the orderid's are present in<br />
table B.<br />
<br />
in this case, I only need to select custid 101 and 103 as one of the orderid (7408) is not present in tablel B.<br />
<br />
can anyone please give me that SQL ? I am using IBM DB2 Database.<br />
<br />
Many Thanks
</div>
</div>


Table A

   custid   orderid
     101      5418
     102      7408
     102      5408
     103      9547
  

 Table B

Orderid
5418
9547
5408

I have 2 tables. From table A I only need to select those custid where all the orderid's are present in
table B.

in this case, I only need to select custid 101 and 103 as one of the orderid (7408) is not present in tablel B.

can anyone please give me that SQL ? I am using IBM DB2 Database.

Many Thanks

SQL Help Needed

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

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

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.