Hi,
I have to query many tables (about 18 tables)
from a database to field a riport in HTML.
I can make the query and it works (I think), but it's a bit strange to
me.
The query looks like this:
select * from table1 f, table2 s, table3 t, table4 fo, table5 fi,
table6 si, table 7 se, table8 e, table9 n, table10 ten, table 11 el,
table 12 tw ...
where f.id=s.id
and f.id=t.id
and f.id=fo.id
and f.id=fi.id
and so on...
Is this the right way, or are there any better solution?
How do the professionals make that big queries?
Thanks in advance!
Regards,
Trebb