Re: where more than 2 column not in a table

[EMAIL PROTECTED] wrote: 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. Your schema has a problem: wagers.name_club is too short. If no club_get_match.name_club value is longer than 20

Re: where more than 2 column not in a table

[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

Re: where more than 2 column not in a table

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,

where more than 2 column not in a table

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. I hope you will help me because I really need it for my study. Thank you in advance, regards, Eva Panjaitan 11104029