from one dan to another..... select man.description as man_description, cat.description as cat_description from main_table as main, manufacturer_table as man, categories_table as cat where main.manufacturer_id = man.manufacturer_id and main.category_id = cat.category_id and title_id = 3
Dan ***Greene*** > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 22, 2003 4:18 PM > To: [EMAIL PROTECTED] > Subject: select statement question > > > how do I get the values of foreign keys, that I have used within a > database > > example > > Main_DB > > Main_Table > PK title_id 3 > FK manufacturer_id 5 > FK category_id 4 > > Manufacturer_Table > PK manufacturer_id 5 > description man. description > > Categories_Table > PK category_id 4 > description cat. description > > my goal is to get > > choice 3 's "man. description" and "cat description" > > I am probably over looking an obvious answer here, but am > making the call > to the bullpen anyway. > > Thank you in advance for your help. > > **DAN** > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
