En query driller

Hejsa jeg er såen det man kalder nOOb inden for det her mysql.

Jeg har den her database
der hedder dvd
Nå jeg så prøver at køre denne her query

SELECT * FROM movies,sounds,langs,category WHERE movies.sound_id = sounds.sounds_id AND movies.lang_id = langs.langs_id AND movies.sub_id = langs.langs_id AND category.category_id = movies.cat_id AND movies.cat_id = 2

Skulle den gerne returnere 2 men der kommer kun 1 igen
Nogen der ved hvorfor ?

Mvh
Krydset

CREATE TABLE `admin_users` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(255) NOT NULL default '',
  `efternavn` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `username` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

# --------------------------------------------------------

#
# Struktur dump for tabellen `category`
#

CREATE TABLE `category` (
  `category_id` int(11) NOT NULL auto_increment,
  `cat` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`category_id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

# --------------------------------------------------------

#
# Struktur dump for tabellen `langs`
#

CREATE TABLE `langs` (
  `langs_id` int(11) NOT NULL auto_increment,
  `lang` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`langs_id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

# --------------------------------------------------------

#
# Struktur dump for tabellen `movies`
#

CREATE TABLE `movies` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `sound_id` int(10) NOT NULL default '0',
  `cat_id` int(10) NOT NULL default '0',
  `length` varchar(255) NOT NULL default '',
  `aar` int(4) unsigned NOT NULL default '0',
  `lang_id` int(10) NOT NULL default '0',
  `sub_id` int(10) NOT NULL default '0',
  `info` text NOT NULL,
  `pic` varchar(255) NOT NULL default '',
  `pic_thumb` varchar(255) NOT NULL default '',
  `date` int(50) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

# --------------------------------------------------------

#
# Struktur dump for tabellen `sounds`
#

CREATE TABLE `sounds` (
  `sounds_id` int(11) NOT NULL auto_increment,
  `sound` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`sounds_id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

# --------------------------------------------------------

#
# Struktur dump for tabellen `users`
#

CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `navn` varchar(255) NOT NULL default '',
  `efternavn` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `username` varchar(255) NOT NULL default '',
  `password` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO