[SQL] SQL syntax for concating values in different rows together

2002-12-10 Thread Elizabeth O'Neill's Office Mail
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

Re: [SQL] SQL syntax for concating values in different rows together

2002-12-10 Thread Roberto Mello
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

Re: [SQL] import sql script

2002-12-10 Thread mark carew
no ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] sql query

2002-12-10 Thread Vijay Uppal
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,

Re: [SQL] SQL syntax for concating values in different rows together

2002-12-10 Thread Joe Conway
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

[SQL] is numeric relational operator problem fixed in v7.3

2002-12-10 Thread jack
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

Re: [SQL] is numeric relational operator problem fixed in v7.3

2002-12-10 Thread Oliver Elphick
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

[SQL] Question

2002-12-10 Thread Jonathan Man
Hi, Can I get a table structure on a function using pgsql?? Thank you very much!! From JONATHAN MAN