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! > > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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