SELECT from 2 tables at the same time

[error_22]

Hi,

I was wondering, is it possible to select information from two fields at the same time?

Thanks in advance
Niklas

[Xenon]

yes, either by join, or by cross selection:

SELECT * FROM table1, table2 WHERE table1.soething = 'gfmnf' AND table2.something='gjdghj' AND table1.anotherthing = table2.anotherthing

[error_22]

Thanks Xenon !! :)

[Xenon]

you're welcome :)