[thelist] SQL View: Join? SubQuery?

rudy r937 at interlog.com
Wed Aug 21 10:36:01 CDT 2002


> I hate to contradict you

hi Joshua

i'm glad you did

i called it an unconventional join, but the syntax i gave was actually
broken

since the comma-separated list is a string, try

   on Table2.names like '%' || Table1.id || '%'

in Susan's case,

   on PerformedPieces like '%' || CompID  || '%'

Susan, Sean was absolutely right, you will save yourself many headaches
down the road by changing the table structure

your idea of using a view is excellent, but that's a separate question,
although it will certainly be better to have a view based on a solid
underlying structure

the only comment i have about Sean's proposed relationship table --

PerformedPieces
ID
ProgramID
CompositionID

is that you probably don't need the ID as the key to this table

use the combined ProgramID and CompositionID as the primary key


rudy




More information about the thelist mailing list