s a relationship to a table that holds the
company data. Since PostgreSQL supports referential integrity you could
extend CmpnyNo in the following way:
CmpnyNo varchar(6) not null references Company
on update cascade
on delete cascade,
Ho
Maik wrote:
>
> Its clear, union concat the two results.
>
> But he can also use this join version, if its the intention.
>
> select t1.id, sum(t1.amount), t2.id, sum(t2.amount) from table1 as t1,
> table2 as t2 where t1.id=t2.id;
>
Yeps, thats another way to write an inner join :-)
Mazzel
Maik wrote:
>
> With "Union" you can create one view.
> Ciao Maik
UNION wouldn't have the desired effect:
the result of a UNION SELECT would look like this:
ID AMOUNT
1 (table1.amount)
2 (table1.amount)
. .
. .
1 (table2.amount)
2 (table2.amount)
What he wants is:
ID TABLE1.AMOUNT
Fons Rave wrote:
>
> I'm writing a program in Delphi.
> In SQL I'm a beginner.
>
> I have a file in which there are records with what people have done. In the file
> are records with name, date, what they have done, time-length, etc. It is
> possible that there are two records that are exactly
t like 'pg_%';
Kind regards,
Nils Zonneveld
--
Alles van waarde is weerloos
Lucebert
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
different bridges for different DBMS's.
HTH,
Nils Zonneveld
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Muhammed Yazici wrote:
>
> hi,
> i'am really new to postgresql and i try it with php ..
>
> Now i have following question :
>
> is it possible to make one query on two databases. I have a database calles
> db1 and one db2 and i want to get :
>
> select * from ":db1:table1" where ":db1:table
Olivier PRENANT wrote:
>
> Sorry to bother,
>
> Just making sure my newsfeed works
>
>
Its seems to work :-)
nils
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAI
procedure? (just curious).
Regards,
Nils Zonneveld
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
