Re: Joins!!
От | Haller Christoph |
---|---|
Тема | Re: Joins!! |
Дата | |
Msg-id | 200111130835.JAA23920@rodos обсуждение исходный текст |
Ответ на | Joins!! (Gurudutt <guru@indvalley.com>) |
Ответы |
Re: Joins!!
|
Список | pgsql-sql |
> > Q 1. Consider the following query, suppose I want the sum of the > tickettabcount and ticketmultabcount, how do I modify my query to get the > same. If I use operator "+" in between these, it's been ignored by the > PgSQL and throws a error!! > > QUERY > ----- > select count(tickettab.tokenid) as tickettabcount, > (select count(tokenid) from ticketmultab > where agentid='danny' and arrivaldate='2001-11-12') as > ticketmultabcount > from tickettab > where tickettab.agentid='danny' and > tickettab.arrivaldate='2001-11-12' > > RESULT > ------- > > > tickettabcount || ticketmultabcount > ------------- ------------------ > 9 2 > Don't use the column name aliasing and it should work: select sum(tickettab.tokenid) + (select sum(tokenid) from ticketmultab where agentid='danny' and arrivaldate='2001-11-12') from tickettab where tickettab.agentid='danny' and tickettab.arrivaldate='2001-11-12' ; > > > Q 2. I join two tables, I get a result set which has values from > both the tables, now if I want to sort the combination of the result > set how do I do that!!, not the individual table result set. > What is so mysterious about your join? To answer your question, it would be very helpful to see the query instead of reading prose. Reagrds, Christoph
В списке pgsql-sql по дате отправления: