topic Re: select from 3 tabs in Application Development and Automation Discussions

select from 3 tabs

Former Member — Mon, 10 Nov 2008 14:49:11 GMT

hi,

hw to fetch records of 3 tables without using join stmt. and with one SELECT stmt.

thanks,

Former Member — Mon, 10 Nov 2008 14:50:41 GMT

Look for any views available for the three tables.

Cheers,

Former Member — Mon, 10 Nov 2008 14:50:43 GMT

create a view , then you can use single slect to fetch .

former_member156446 — Mon, 10 Nov 2008 15:00:15 GMT

A database View can be created using all the primary keys of all the three tables and fetch data in One select statement.