And actually, if you DO want duplicate rows - use UNION ALL on the same table:
(SELECT DISTINCT table1.field AS field1 FROM TABLE AS table1) UNION ALL (SELECT DISTINCT table2.field AS field1 FROM TABLE AS table2) ORDER BY field1 Not sure if your db will handle it the same. Adam. > -----Original Message----- > From: Cantrell, Adam [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 05, 2002 1:24 PM > To: CF-Talk > Subject: RE: Query help > > > Output two rows or two columns? > > I don't know about rows, but columns would be fairly easy: > > SELECT DISTINCT > field AS field1, > field AS field2 > FROM TABLE WHERE 0=0 > > Adam. > > > > > -----Original Message----- > > From: stas [mailto:[EMAIL PROTECTED]] > > Sent: Friday, April 05, 2002 1:15 PM > > To: CF-Talk > > Subject: Query help > > > > > > Hello, > > > > I have a table one column of which is a foreign key. For each > > unique value > > in this column I'd like to output 2 rows containing this > > value. Obviously, > > that would be pretty easy in CF, but I need it to be > > completely in SQL. > > Thanks for any tips! > > > > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
