Re: View a return of Select

2001-03-23 Thread Bob Hall
> I have to check to MySQL is able to support our requirements >and I would >like to view a return of n columns like only one register, thats is posible >with MySQL? > For example i have 2 tables , 1 table have products and this >table habe 3 >colums ID , name, Id_price and the other

RE: View a return of Select

2001-03-23 Thread Cal Evans
Not without some procedural code in a different language or creating temp tables. (Both are bad ideas.) Using straight SQL, the best you can get it 3 records, each with all the info from table 1 and a different row from table 2. HTH, Cal http://www.calevans.com -Original Message- From: