Re: Query and join problem with null values
ity >> >> WHERE >> people.zip = city.zip >> and people.peopleId = "2"; >> >> I don't get any selection... wheras I expect : >> +--+--+--+ >> | PeopleID | zip | city | >> +--+--+--+ >
RE: Query and join problem with null values
: > >CREATE TABLE `people` ( > `peopleId` tinyint(1) unsigned NOT NULL auto_increment, > `zip` varchar(255) default NULL, > PRIMARY KEY (`peopleId`) >) > >CREATE TABLE `city` ( > `zip` tinyint(1) unsigned NOT NULL auto_increment, > `city` varchar(255) default NULL, > PRIMARY KEY (`zip`) >)