select from 3 tabs

[Former Member]

hi,

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

thanks,

[Former Member]

hi,

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

thanks,

[Former Member]

Look for any views available for the three tables.

Cheers,

KD

[Former Member]

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

[former_member156446]

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