Lookup Table - use inner join

This public forum is for user-to-user discussions of ASP.NET Maker. Note that this is not support forum.
Post Reply
Thomas.Hoffner
User
Posts: 35

Lookup Table - use inner join

Post by Thomas.Hoffner »

How can I use an "INNER JOIN" command in a "LOOKUP TABLE" Definition.

e.g.
select SPSNR, BEZ from tab_tankMode
INNER JOIN tab_Tank on
tab_Tank.MOD_NR1 = tab_TankMode.SPSNR OR tab_Tank.MOD_NR2 = tab_TankMode.SPSNR
where tab_Tank.ZNR LIKE N'FG0100'

In my example in my LOOKUP TABLE is:

Table Name: tab_tankMode
Link Field : SPSNR
DIsplay Fields 1: SPSNR
DIsplay Fields 1: BEZ

Now I want to add the SQL-Command:

INNER JOIN tab_Tank on
tab_Tank.MOD_NR1 = tab_TankMode.SPSNR OR tab_Tank.MOD_NR2 = tab_TankMode.SPSNR
where tab_Tank.ZNR LIKE N'FG0100'

Can anybody help me


motfs
User
Posts: 258

Post by motfs »

You can create a Database View first for the Lookup table.


Thomas.Hoffner
User
Posts: 35

Post by Thomas.Hoffner »

Thanks - The Database view is the only way in ASP.NET Maker to solve that function.


Thomas.Hoffner
User
Posts: 35

Post by Thomas.Hoffner »

If you do not want to have a new view in your database, you can also use a "CUSTOMER VIEW" inside your ASP.NET Maker Project.

In my case it is better, because the database Manager do not allowed new database view.


Post Reply