Skip site navigation (1) Skip section navigation (2)

SQL Problem

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: SQL Problem
Date: 2005-06-28 22:41:48
Message-ID: 20050628224148.92649.qmail@web33301.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
i'm not sure if this is the best place to ask (if
there is a better mailing list, please let me know)...

i have a sql problem.  i have the following query...

$sql_notes = "SELECT notes.assembly_notes,
notes.assembly_notes_contact_id " .
			
"FROM t_product AS prod, t_link_product_assembly_notes
AS link, t_assembly_notes AS notes " .
			
"WHERE link.product_id = prod.product_id " .
"AND link.assembly_notes_id = notes.assembly_notes_id
".
"AND link.product_id = " . $product_id;

it works great except for one problem.  i want the
assembly_notes_contact (the actual name) instead of
the assembly_notes_contact_id.  the result of this
query is stored in an array and then i iterate through
the array before displaying the data.

assembly_notes_contact_id is a foreign key to the
employee table's primary key.  i want to be able to
query the db and get the employee name (instead of his
id) into the recordset array.  the employee name is
the same as the assembly_notes_contact.

is this possible?  if so, how?

tia...


		
__________________________________ 
Yahoo! Mail Mobile 
Take Yahoo! Mail with you! Check email on your mobile phone. 
http://mobile.yahoo.com/learn/mail 

In response to

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2005-06-28 22:53:23
Subject: Re: SQL Problem
Previous:From: SeanDate: 2005-06-28 20:20:35
Subject: Sstored Procedures

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group