[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 (co

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, sal

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 area/r

[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 Y

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 broadcast)

[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