I'm definitely not an expert, but I think you work your way back from chanid to get the cardtype:
SELECT cardtype FROM recorded, channel, cardinput, capturecard where recorded.chanid = channel.chanid and channel.sourceid = cardinput.sourceid and cardinput.cardid = capturecard.cardid ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Mvpmc-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mvpmc-users mvpmc wiki: http://mvpmc.wikispaces.com/
