> > >This is my table: > > > > > >CREATE TABLE items ( > > > id int(10) UNSIGNED NOT NULL default '0', > > > itemid int(10) UNSIGNED NOT NULL auto_increment, > > > PRIMARY KEY (`itemid`) > > >); > > > > > >I'd like to get 100 itemid's for each id.
I guess I could solve my problem with a subselect. Thanks, Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]