Hi
Can someone please help me.
I have two tables in my database a complaint table and a resolution table.
One complaint may have several resolutions. I am trying to build a report
that will give me the complaint details and all the resolution descriptions
for a complaint in one text area/row
On Tue, Dec 10, 2002 at 12:27:34PM +, Elizabeth O'Neill's Office Mail wrote:
Hi
Can someone please help me.
I have two tables in my database a complaint table and a resolution table.
One complaint may have several resolutions. I am trying to build a report
that will give me the
no
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Hi I have a problem forming a query
I have 3 tables salary(hrs, clock_in , clock_out)
Break ( date, employe_id,
net_time, break_in, break_out)
Employee(employee_id, pay_rate,
name)
I need to get an hourly report till the current time for
that day stating name, hour, no of hours,
Elizabeth O'Neill's Office Mail wrote:
I have two tables in my database a complaint table and a resolution table.
One complaint may have several resolutions. I am trying to build a report
that will give me the complaint details and all the resolution descriptions
for a complaint in one text
Does the following now works in postgreSQL v7.3?
Select *
from a_table
where num1 10;
*** type of num1 is NUMERIC (12,2)
Jack
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister
On Wed, 2002-12-11 at 02:54, jack wrote:
Does the following now works in postgreSQL v7.3?
Select *
from a_table
where num1 10;
*** type of num1 is NUMERIC (12,2)
It works
--
Oliver Elphick [EMAIL PROTECTED]
LFIX Limited
---(end of
Hi,
Can I get a table structure on a function using
pgsql??
Thank you very much!!
From JONATHAN MAN