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
ON sadb.ID = dmb.ID
WHERE dyr med ben.ID ID=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' ??