CREATE TABLE `club_get_match` ( `id_match` bigint(100) NOT NULL default '0', `name_club` varchar(30) NOT NULL default '', `status` varchar(30) default NULL, `prediction_match` varchar(5) NOT NULL default '', `equal_match` char(3) NOT NULL default '', `score` varchar(50) default NULL, `scorerr` varchar(10) default NULL, PRIMARY KEY (`id_match`,`name_club`) );
CREATE TABLE `detail_club_member` ( `id_member` bigint(20) NOT NULL default '0', `choose` varchar(50) NOT NULL default '', `name_club` varchar(30) NOT NULL default '', PRIMARY KEY (`id_member`,`name_club`) ); CREATE TABLE `wager` ( `id_match` bigint(100) NOT NULL default '0', `id_member` varchar(8) NOT NULL default '', `total_wager` bigint(10) NOT NULL default '0', `total_money` bigint(20) NOT NULL default '0', `name_club` varchar(20) NOT NULL default '', `time_update` datetime default '0000-00-00 00:00:00', PRIMARY KEY (`id_match`,`id_member`,`name_club`) ); I want to select a list, where it was registered in tbl club_get_match with Id- Member in tbl detail_club_member, but it's not registered in tbl wager. Quoting Peter Brawley <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] wrote: > > Sory if my question makes you confused > > I've a problem with my sintax, > > I don't know how to select a list, whether it's not registered in another > > > table, but it have 2 IDs. > > > Not enough info. Show the Create Table statements, a bit of data, and > the desired result. > > PB > > I hope you will help me because I really need it for my study. > > > > Thank you in advance, > > > > regards, > > Eva Panjaitan > > 11104029 > > Student of Del Polytechnic of Informatics > > Sitoluama - Laguboti > > Toba Samosir > > Sumatera Utara > > > > > > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.394 / Virus Database: 268.7.3/350 - Release Date: 5/28/2006 > > regards, Eva Panjaitan 11104029 Student of Del Polytechnic of Informatics Sitoluama - Laguboti Toba Samosir Sumatera Utara -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
