Skip to Content
0
Former Member
Dec 03, 2008 at 09:31 AM

Select Statement

22 Views

Hi All,

Requirement is that.

Fetch the data from Table1.

After fetching data from Table1. I need to take the data from Table2, based on the values retrived from Table1. If atleast 1 entry is found in Table2. I need to stop the select.

How to achive this.

I have written code as follows.

Select *

fom Table1 base on condition.

Then,

I have written select 2 for table Table2.

select *

from Table2 for all entries in Table1.