topic conditions while creating views in Application Development and Automation Discussions

conditions while creating views

Former Member — Mon, 27 Nov 2006 07:04:32 GMT

Hi,

I have 2 db tables A and B. And I need to have a condition while joining these two tables. i have a field called date in A and date1 and date 2 in B.

The condition i would like to incorporate is A-date should lie between B-date1 and B-date2 (B-date1<A-date<B-date2).

I've tried out Maintenance Views and i can only give a comparative value in the selection conditions (say A-date eq sy-datum).

Can anyone suggest me how to go about this.

Thanks in advance...

Naren

Re: conditions while creating views

Former Member — Mon, 27 Nov 2006 07:12:48 GMT

use inner join so that u can get the all the fields from left table and the common fields from right table

Re: conditions while creating views

Former Member — Mon, 27 Nov 2006 07:19:36 GMT

I don't believe you can create a view like that.

U should explain what you need to do.

Max

Re: conditions while creating views

Former Member — Mon, 27 Nov 2006 07:22:07 GMT

hi,

why do n't u sue FOR ALL ENTRIES..statement here ..?

Regds,

vinsa.R

Re: conditions while creating views

Former Member — Mon, 27 Nov 2006 08:12:05 GMT

The exact scenario is, i have 3 DB tables and I've created a view with the join conditions. I need to incorporate a condition(as I've mentioned in my query)on 2 of the DB tables, which I couldn't do. Hope u understood the requirement.

so in total if I go to the View and see the contents i need to have the entries which match the exact requirement.

the alternate solution would be to create a batch program which would have the conditions that couldn't be met during the build and append the required entries to another DB table and so if I go to the new DB table i can have all the required entries.

But I do want to have this alternate solution only if nothing else can be done.

Re: conditions while creating views

Former Member — Mon, 27 Nov 2006 08:33:44 GMT

good

go through these links which ll gie you idea about view with join statement.

http://www.braincorp.com.au/products/information-technology/sql/database-concepts-and-technologies/database-technologies-part-2-introduction-to-sq/

http://dev.mysql.com/doc/maxdb/en/6d/117c44d14811d2a97400a0c9449261/content.htm

thanks

mrutyun^

Re: conditions while creating views

Former Member — Tue, 15 Jan 2008 03:35:01 GMT

Requirement changed!!