Ok, I see.

Thanks!



>>I have 3 tables:
>>
>>

>> Media_Orders
>>  |-< Campaigns
>>      |-< Show_Title
>>

>>
>>The problem is that the Campaign Id is not stored on Media_Orders, but
>>Show_Title is.
>>
>>Media_Orders.Show_Title is a foreign key onto Show_Title.Id.
>>Show_Title.Campaign is a a foreign key onto Campaign.Id.
>>
>>I need to pull all campaign records for the Media_Order records.
>>
>>Anyone?
>
>Unless I'm missing something it looks like a pretty standard three-table join
>
>

>select *
>from Campaigns
>inner join Show_Title
>on Campain.Id = Show_Title.Campaign_ID
>inner join Media_Orders
>on Show_Title.ID = Media_Orders.Show_Title
>