Skip to Content
0
Former Member
Aug 30, 2009 at 06:43 AM

How to fetch data from 2 tables

855 Views

Hi Experts,

I am using 2 Ztables.Let us assume that there are 2 fields in Table1 as a and b and 2nd Table contain c as field.I want to retrive data from these tables by combining the fields of Table1 with that of 2.

Eg: I want to compare a+b with c and fetch records.

Is there any logic to combine 2 fields and compare with 3rd field using a single select statement?

Regds,

Sam.