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

Reply via email to