Sub Selects, Alias Names and stored procedures

2005-11-04 Thread Gordon Bruce
After reading one of the recent posts from Gobi [EMAIL PROTECTED] I took his successful query and modified it for one of my tables. It indeed produce the correct result, but in the process raised some questions. 1. Why do list_ID and acct_ID not have to be qualified with a table name

Re: Sub Selects, Alias Names and stored procedures

2005-11-04 Thread Rhino
:-) Rhino - Original Message - From: Gordon Bruce [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Friday, November 04, 2005 2:51 PM Subject: Sub Selects, Alias Names and stored procedures After reading one of the recent posts from Gobi [EMAIL PROTECTED] I took his successful query