Oleg Broytmann wrote:
> On Fri, Jun 08, 2007 at 06:11:11PM +0100, Nick Murdoch wrote:
>> The relevant part there is SELECT * from (SELECT * FROM vip_comp_details
>> UNION SELECT * FROM contact_details ), I guess.
>
>UNION is meaningless for high-level SQLObject API. The only way to do
> UNION
On Fri, Jun 08, 2007 at 06:11:11PM +0100, Nick Murdoch wrote:
> The relevant part there is SELECT * from (SELECT * FROM vip_comp_details
> UNION SELECT * FROM contact_details ), I guess.
UNION is meaningless for high-level SQLObject API. The only way to do
UNION is:
connection.queryAll("SELEC
Hi,
That doesn't seem to be quite what I need. I basically have two tables
with identical headers in the SQL database (not the best design, I know,
but it evolved that way from something a lot simpler.)
I've managed to work out what the SQL statement (Postgres) would be to
do what I want, if t
Do a (left) join. (About joins: http://www.w3schools.com/sql/sql_join.asp)
And on how to do it with SQLObject:
http://www.sqlobject.org/FAQ.html#how-can-i-do-a-left-join and
http://www.sqlobject.org/SQLObject.html#left-join-and-other-joins
TiNo
2007/6/8, Nick Murdoch <[EMAIL PROTECTED]>:
Hi al
