Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How To Do This Query
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01086651
Message ID:
01086666
Views:
8
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
>
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people
Previous
Reply
Map
View

Click here to load this message in the networking platform