To sætninger i en

not easy to give an answer without seeing how your tables are related and also what you want to see in the result.

why dont you try using the query builder? You know how your tables are related and also what you want in the result so you should be able to put something together.
And before we use too much time here, what is .... LIMIT 0,15
This isnt standard Access SQL!

axkris>You also have a number of open question in this catgeory!

Hej Terry

Tak for tippet - jeg kigger om lidt på at få lukket nogle spg.

Her er min struktur:

CREATE TABLE LINKS_FSH (
  ID int(11) NOT NULL auto_increment,
  MemberID int(11) NOT NULL default '0',
  CategoryID int(11) NOT NULL default '0',
  Email_sent text NOT NULL,
  Email_to text,
  Url text NOT NULL,
  Title text NOT NULL,
  Picture text NOT NULL,
  Description text NOT NULL,
  Type text NOT NULL,
  Language text NOT NULL,
  Publish date NOT NULL default '0000-00-00',
  Created date NOT NULL default '0000-00-00',
  FSH text NOT NULL,
  Broken int(11) NOT NULL default '0',
  Click int(11) NOT NULL default '0',
  LastIP text NOT NULL,
  Approved text NOT NULL,
  PRIMARY KEY  (ID),
  KEY ID (ID)
) TYPE=MyISAM;

CREATE TABLE FORUM_MEMBERS (
  MEMBER_ID int(11) NOT NULL auto_increment,
  M_STATUS smallint(6) default '0',
  M_NAME varchar(75) default '',
  M_USERNAME varchar(150) default '',
  M_PASSWORD varchar(65) default '',
  M_EMAIL varchar(50) default '',
  M_COUNTRY varchar(50) default '',
  M_HOMEPAGE varchar(255) default '',
  M_SIG text,
  M_VIEW_SIG smallint(6) default '1',
  M_SIG_DEFAULT smallint(6) default '1',
  M_DEFAULT_VIEW int(11) default '1',
  M_NEWSLETTER int(11) default '1',
  M_LEVEL smallint(6) default '1',
  M_AIM varchar(150) default '',
  M_ICQ varchar(150) default '',
  M_MSN varchar(150) default '',
  M_YAHOO varchar(150) default '',
  M_POSTS int(11) default '0',
  M_DATE varchar(14) default '',
  M_LASTHEREDATE varchar(14) default '',
  M_LASTPOSTDATE varchar(14) default '',
  M_TITLE varchar(50) default '',
  M_SUBSCRIPTION smallint(6) default '0',
  M_HIDE_EMAIL smallint(6) default '0',
  M_RECEIVE_EMAIL smallint(6) default '1',
  M_LAST_IP varchar(15) default '000.000.000.000',
  M_IP varchar(15) default '000.000.000.000',
  M_FIRSTNAME varchar(100) default '',
  M_LASTNAME varchar(100) default '',
  M_OCCUPATION varchar(255) default '',
  M_SEX varchar(50) default '',
  M_AGE varchar(10) default '',
  M_DOB varchar(8) default '',
  M_HOBBIES text,
  M_LNEWS text,
  M_QUOTE text,
  M_BIO text,
  M_MARSTATUS varchar(100) default '',
  M_LINK1 varchar(255) default '',
  M_LINK2 varchar(255) default '',
  M_CITY varchar(100) default '',
  M_STATE varchar(100) default '',
  M_PHOTO_URL varchar(255) default '',
  M_KEY varchar(32) default '',
  M_NEWEMAIL varchar(50) default '',
  M_PWKEY varchar(32) default '',
  M_SHA256 smallint(6) default '1',
  M_VISITORS_TO int(11) NOT NULL default '0',
  M_VISITORS_FROM int(11) NOT NULL default '0',
  M_FSH_COUNT int(11) NOT NULL default '0',
  M_MISC_COUNT int(11) NOT NULL default '0',
  PRIMARY KEY  (MEMBER_ID),
  KEY FORUM_MEMBERS_MEMBER_ID (MEMBER_ID)
) TYPE=MyISAM;

CREATE TABLE LINKS_GROUPS (
  ID int(11) NOT NULL auto_increment,
  Title text NOT NULL,
  PRIMARY KEY  (ID),
  KEY ID (ID)
) TYPE=MyISAM;

Resultatet skal være, at jeg kan udskrive M_Name.

Resultatet skal være, at jeg (OGSÅ) kan udskrive M_Name.

this isnt Access is it?

Nej, det er mysql - men principperne er det samme.

Lukker og slukker :-)

No, Access and MySQL syntax arent the same, thats why I previously asked
what this is! Access doesnt understand it

"LIMIT 0,15"