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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2005-06-28 22:53:23 | Re: SQL Problem |
Previous Message | Sean | 2005-06-28 20:20:35 | Sstored Procedures |