Hi.
Can anybody take me reference on Database design tool with PostgreSQL
support.
thanks.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
select products.*, manufactors.*
from products, manufactors
where products.manufactor_id=manufactors.manufactor_id
and ( products.product_description like 'param%' or
manufactors.manufactor_description like 'param%');
regards
Jason Davis ?:
>I have 2 tables, one is products and one is manu
For implicit modification you can use a trigger on the table. If you
wan't store this data, you can use view.
andres javier garcia garcia ?:
>Hi;
>
>I've got a table with two fields and about 3000 rows, the second one is a
>character field, what can have about twenty different values; of c
jack :
select * from purchase as p
where purchase_date >= ( select min(ppp.purchase_date)
from (select pp.purchase_date
from purchase as pp
where p.item_no = pp.item_no
jack :
select * from purchase as p
where purchase_date >= ( select min(ppp.purchase_date)
from (select pp.purchase_date
from purchase as pp
where p.item_no = pp.item_no
jack :
select * from purchase as p
where purchase_date >= ( select min(ppp.purchase_date)
from (select pp.purchase_date
from purchase as pp
where p.item_no = pp.item_no
