Making a 2 tables join in phpmyadmin

Question

Been trying to make a join between 2 of my tables, tried all kind of inputs but all seem wrong, could anyone help me?

Both tables got "ID" in common.

SELECT dmb.Antal ben

     , dmb.ID

     , dmb.Navn

     , sadb.ID

     , sadb.Pris

  FROM dmb

 INNER

  JOIN sadb

    ON sadb.ID = dmb.ID

 WHERE dyr med ben.ID ID=1

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

My guess is that you are incorporating spaces in your table and column names. This is a seriously bad idea. Also, you seem to be uncertain what the name of your tables are. With lots of assumptions, a valid query may look like this:

SELECT dmb.`Antal ben`
     , dmb.ID
     , dmb.Navn
     , sadb.ID
     , sadb.Pris
  FROM `dyr med ben` dmb
 INNER
  JOIN sadb
    ON sadb.ID = dmb.ID
 WHERE dmb.ID = 1

Also, aren't vertebrates 'virveldyr' ??

Making a 2 tables join in phpmyadmin

Sign up