I'm working on a project to syndicate library content with RSS.... and learn .NET, C#, and AJAX

Tuesday, July 3, 2007

SQL Query

Apparently I just needed a good night's sleep:

select [rdb-production].[dbo].items.item_id, [rdb-production].[dbo].items.title,
[jewel-dev].[dbo].JMU_List_Items.JMU_Lists_Items_ID
FROM [rdb-production].[dbo].Items, [jewel-dev].[dbo].JMU_List_Items
WHERE ([rdb-production].[dbo].Items.Item_ID = [jewel-dev].dbo].JMU_List_Items.Item_ID) AND
([jewel-dev].[dbo].JMU_List_Items.JMU_Lists_ID = 38)

No comments: