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;
+--------+--------+
| var1 | var2 |
+--------+--------+
| value1 | value2 |
+--------+--------+
What I need to do is something similar, but producing multiple records
without referencing any tables:
+--------+--------+
| var1 | var2 |
+--------+--------+
| value1 | value2 |
| value3 | value4 |
| value5 | value6 |
+--------+--------+
Thank you in advance for any advice you can give.
