SQL join issue with multiple columns with the same name but different value

Question

I have a bit of an issue with my SQL statement. It is a bit hard to explain so I will show you:

SELECT  exp_channel_data.field_id_102,
        exp_channel_data.field_id_104,
        exp_channel_data.field_id_126,
        exp_channels.deft_status
FROM exp_channel_data
  INNER JOIN exp_channels
    ON exp_channels.channel_id = exp_channel_data.channel_id
  INNER JOIN exp_channel_titles
    ON exp_channels.channel_id = exp_channel_titles.channel_id
WHERE exp_channels.channel_id = 18
AND exp_channel_titles.channel_id = 19

The bit that doesn't work is the AND exp_channel_titles.channel_id = 19

Any ideas on how to solve this issue?

Thanks in advance!

podiluska · Accepted Answer · 2012-06-18 08:55:58Z

6

You've joined on exp_channels.channel_id = exp_channel_titles.channel_id and are filtering on

exp_channels.channel_id = 18 
exp_channel_titles.channel_id = 19

so there can never be any results

answered Jun 18, 2012 at 8:55

podiluska

51.6k7 gold badges102 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL join issue with multiple columns with the same name but different value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related