[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