Walaa wrote:
is it possible to program and query this following query-statement in llblgen:
(without inner-join)
select * from table1, table2
where table1.id = table2.tab1_id
What do you mean without inner-join? what difference should it make?
It doesn't matter if you don't have the relation defined in the database.
Anyway if you want to fetch fields from more than one table, then you should use a flat structure, like the TypedList(defined in the Designer) or the DynamicList(defined in code).
sorry, i mean i want to join without a physically relation between tab1 and tab2.
physically:
select * from table1, table2
where table1.pk = table2.fk
logically:
select * from table1, table2
where table1.field2 = table2.fk
field2 is a key from table1. it could be exist more then once in this table...
thanx in forward...
pate
