Hi,
I'm in the process of writing a module and was wondering if it was possible to perform SQL JOINS with the db query method?
So instead of having the one huge table of usernames/domains have the two with username/domain_id and domain_id/domain. This is to perform number lookup and routing functions so will be quite big.
If not is it possible to tell the db module what SQL it should execute??
Many Thanks,
Alan
On 11-10-2005 14:57, Alan wrote:
Hi,
I'm in the process of writing a module and was wondering if it was possible to perform SQL JOINS with the db query method?
No, but you can use raw_query function instead (it would make your module rely on one database unless you use standard SQL query).
Jan.