Select multiple rows with no reference table

2008-01-15 Thread Mark Wexler
Hey folks. I just joined the list. Please let me know if I am not posting to the correct list. I am trying to use a select statement to retreive multiple records without a reference table. Obviously retreiving a single record is simple enough: mysql SELECT 'value1' AS var1, 'value2' AS var2;

Re: Select multiple rows with no reference table

2008-01-15 Thread Baron Schwartz
Hi Mark, On Jan 15, 2008 12:51 PM, Mark Wexler [EMAIL PROTECTED] wrote: Hey folks. I just joined the list. Please let me know if I am not posting to the correct list. You're in the right list. I am trying to use a select statement to retreive multiple records without a reference table.

RE: Select multiple rows with no reference table

2008-01-15 Thread Mark Wexler
Thank you -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baron Schwartz Sent: Tuesday, January 15, 2008 1:54 PM To: Mark Wexler Cc: mysql@lists.mysql.com Subject: Re: Select multiple rows with no reference table Hi Mark, On Jan 15, 2008 12:51 PM