[SOLVED] joining table twice?

[delphi123]

Hi folks,

 

Am really struggling with this one, I've got a single table (out of my control unfortunately) which has data stored in it, two fields I need are site url and site description, these are identified by their ids of 18 and 19 respectively as you can see in this screenshot:

 

 

 

Now I'm trying to join these values as new columns to another table, but it's just not working I can get one working fine, just not both, can anyone help?

 

SELECT

urldb.data_txt,

descdb.data_txt,

jos_sobi2_item.title

FROM

jos_sobi2_fields_data AS urldb ON urldb.fieldid = 18

Inner Join jos_sobi2_fields_data AS descdb ON descdb.itemid = urldb.itemid AND urldb.fieldid = 19

Inner Join jos_sobi2_item ON urldb.itemid = jos_sobi2_item.itemid

[Mchl]

SELECT
urldb.data_txt,
descdb.data_txt,
jos_sobi2_item.title
FROM
jos_sobi2_fields_data AS urldb
INNER JOIN
jos_sobi2_fields_data AS descdb
ON descdb.itemid = urldb.itemid AND descdb.fieldid = 19 AND urldb.fieldid = 18
INNER JOIN
jos_sobi2_item 
ON urldb.itemid = jos_sobi2_item.itemid

[delphi123]

great stuff, thanks!