I'm using this query with executesql(), Thanks to all for the support!!
El sábado, 16 de febrero de 2013 15:23:00 UTC-3, Niphlod escribió:
>
> neither.... let's leave alone event('name') that isn't in the table.
> that query returns the event id for each device_id in the events table,
> and attaches to it brand and location from the devices table. additionally,
> it appends the date to it.
>
> the only way to retrieve that set in one query is
>
> select a.id, a.date, b.brand, b.location from events a, devices b
> where
> a.device_id = b.id
> and a.id in (
> select max(id) from events
> group by device_id
> )
>
>
>
>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
