IE.
Database structure:
Expand|Select|Wrap|Line Numbers
- CREATE TABLE `books` (
- `ColIndex` smallint(3) unsigned NOT NULL,
- `Vol` tinyint(3) unsigned default NULL,
- `Series` tinytext,
- `Title` tinytext NOT NULL,
- `Author` tinytext NOT NULL,
- `PubYear` tinytext NOT NULL,
- `Publisher` tinytext NOT NULL,
- `ISBN` char(10) NOT NULL,
- `ColStatus` tinytext NOT NULL,
- `BookId` smallint(5) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Books I own';
310, 8, 'Sabrina, the Teenage Witch', 'Salem On Trial', 'Weiss, David Cody, Weiss, Bobbi J. G.', '1998', 'Simon Spotlight Entertainment', '0671017578', 'In Collection', 692
I want it to be:
310, 8, 'Sabrina, the Teenage Witch', 'Salem On Trial', '163, 144', '1998', 'Simon Spotlight Entertainment', '0671017578', 'In Collection', 692
When I use the query:
Expand|Select|Wrap|Line Numbers
- SELECT * FROM books, authors WHERE ColIndex = 310 AND books.Author = authors.AuthorId
Any help would be appreciated, thanks.