I have a table called PARTS and another called KITS. Joining the two is a fkey table, KITPARTS. A single part can be in more than one kit. I'd like to make a report like this...
KIT PARTS Kit 1 Part One Part Two Kit 2 Part Two Part Three Normally I'd do this in code, but for this project I'm trying to keep the SQL in the SQL... ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Firebird-odbc-devel mailing list Firebird-odbc-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel