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